How does this look?
Code:SELECT TRUNC(date, 'WW'), TELCO, REASON, COUNT(*) FROM TABLE1 WHERE DATE > TRUNC(SYSDATE, 'YYYY') GROUP BY TRUNC(DATE, 'WW'), TELCO, REASON ORDER BY 1,2,3;
|
Results 1 to 2 of 2
Threaded View
|
Click Here to Expand Forum to Full Width |