Query w/Group By

From: <amerar_at_iwc.net>
Date: Wed, 27 Feb 2008 11:38:59 -0800 (PST)
Message-ID: <6677eb82-af85-4b0b-8f4e-a713b0ff7af4@d62g2000hsf.googlegroups.com>

Who do management people always want it complex?

I need to run this query grouping by user Id and month:

SELECT userid||','||count(*)||','||sum(tranamt_n) FROM ej1
WHERE effctvdate>=to_date('01/01/2007','mm/dd/yyyy') and corrstat=' ' and tranamt_n>0
and officename='Linebarger'
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

Original text of this message