Welcome Guest, you are in: <root> • Login

Page History: OE PRODUCT_PRICES (view)

Compare Page Revisions

1 0 Current 1 0

« Older Revision - Back to Page History - Current Revision

Page Revision: 2010/06/24 07:59

wikibot ¶

View	OE.PRODUCT_PRICES

Source ¶

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

References ¶

Dependency Type	Object Type	Referenced Object
Select	Table	OE.PRODUCT_INFORMATION