ScrewTurn Wiki
Navigation
Main Page
Random Page
Create a new Page
All Pages
Categories
Administration
File Management
Login/Logout
Language Selection
Your Profile
Create Account
Quick Search
Advanced Search »
Back
History
OE.ACCOUNT_MANAGERS_(view)
== wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- valign="top" | '''View''' | OE.ACCOUNT_MANAGERS |} === Source === {{{{<nowiki> CREATE OR REPLACE VIEW OE.ACCOUNT_MANAGERS AS SELECT c.account_mgr_id ACCT_MGR, cr.region_id REGION, c.cust_address.country_id COUNTRY, c.cust_address.state_province PROVINCE, count(*) NUM_CUSTOMERS FROM customers c, countries cr WHERE c.cust_address.country_id = cr.country_id GROUP BY ROLLUP (c.account_mgr_id, cr.region_id, c.cust_address.country_id, c.cust_address.state_province) </nowiki>}}}}
ScrewTurn Wiki version 2.0.36. Some of the icons created by
FamFamFam
.