OE.PRODUCT PRICES (view)

From dbscript Online Help
Revision as of 10:35, 27 August 2011 by Bot (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

wikibot[edit]

View OE.PRODUCT_PRICES

Source[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