Query w/Group By
Date: Wed, 27 Feb 2008 11:38:59 -0800 (PST)
Who do management people always want it complex?
I need to run this query grouping by user Id and month:
WHERE effctvdate>=to_date('01/01/2007','mm/dd/yyyy') and corrstat=' ' and tranamt_n>0
group by userid, TO_CHAR(SYSDATE,'MM');
I have yet to figure this one out........ Received on Wed Feb 27 2008 - 13:38:59 CST