Sorry,
I should try group by department before group by to_char(transdate,'YYYY'), to_char(transdate,'Q');
Printable View
Sorry,
I should try group by department before group by to_char(transdate,'YYYY'), to_char(transdate,'Q');
Try those analytical functions provided by oracle.
http://www.dbasupport.com/forums/sho...?threadid=7586
Sam