Difference between revisions of "OE.ACCOUNT MANAGERS (view)"
| Line 10: | Line 10: | ||
<pre> | <pre> | ||
| − | CREATE OR REPLACE SELECT c.account_mgr_id ACCT_MGR, | + | CREATE OR REPLACE VIEW OE.ACCOUNT_MANAGERS AS |
| + | SELECT c.account_mgr_id ACCT_MGR, | ||
cr.region_id REGION, | cr.region_id REGION, | ||
c.cust_address.country_id COUNTRY, | c.cust_address.country_id COUNTRY, | ||
Revision as of 21:10, 24 August 2009
wikibot
| view | OE.ACCOUNT_MANAGERS |
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)
