Hi,

I am Venu and I use DB2 V7.2
I wanted to know how to get the subtotals for the below table structure

Date Name Earnings
1-Apr-2006 Andy 100
1-Apr-2006 Cathy 100
1-Apr-2006 Andy 100
1-Apr-2006 Cathy 100
2-Apr-2006 Andy 300
2-Apr-2006 Cathy 300
2-Apr-2006 Andy 300
2-Apr-2006 Cathy 300


Expecting Result:
----------------
Date Name Earnings
1-Apr-2006 Andy 200
Cathy 200
400
2-Apr-2006 Andy 600
Cathy 600
1200

Please let me know if the above result is achievable
Thanks
Venu

Does DB2 have the standard group by implementation? If so, have you
tried that?

venu wrote: