Welcome
Guest
, you are in:
<root>
•
Login
devio dbscript ScrewTurn Wiki
Navigation
¶
Main Page
Random Page
Create a new Page
All Pages
Categories
Navigation Paths
Administration
File Management
Create Account
Search the wiki
»
Back
OE PRODUCT_PRICES (view)
Modified on 2011/08/27 12:10
by
wikibot
Categorized as
Uncategorized
== wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- valign="top" | '''View''' | OE.PRODUCT_PRICES |} === Source === {{{{<nowiki> 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 </nowiki>}}}}
ScrewTurn Wiki
version 3.0.1.400. Some of the icons created by
FamFamFam
.