Welcome Guest, you are in: Login

devio dbscript ScrewTurn Wiki

RSS RSS

Navigation





Search the wiki
»

PoweredBy

OE PRODUCT_PRICES (view)

RSS
Modified on 2011/08/27 12:10 by wikibot Categorized as Uncategorized

wikibot

ViewOE.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

ScrewTurn Wiki version 3.0.1.400. Some of the icons created by FamFamFam.