|
|
| Line 17: |
Line 17: |
| | GROUP BY category_id | | GROUP BY category_id |
| | </pre> | | </pre> |
| − |
| |
| − | === References ===
| |
| − | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| |
| − | |- style="background:silver"
| |
| − | | '''Dependency Type
| |
| − | | '''Object Type
| |
| − | | '''Referenced Object
| |
| − |
| |
| − | |- valign="top"
| |
| − | | Select
| |
| − | | Table
| |
| − | | [[OE.PRODUCT_INFORMATION_(table)|OE.PRODUCT_INFORMATION]]
| |
| − |
| |
| − | |}
| |
Latest revision as of 10:35, 27 August 2011
wikibot[edit]
CREATE OR REPLACE VIEW OE.PRODUCT_PRICES AS
SELECT category_id
, COUNT(*) as "#_OF_PRODUCTS"
, MIN(list_price) as low_price
, MAX(list_price) as high_price
FROM product_information
GROUP BY category_id
