var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: SUM query
I have data in my STAT table as follows
TSTAMP QMGR QNAME ENQ DEQ
... .. ...... 59 1
.. .. ... 59 29
... .. ... 59 58
I want out put as follows
QMGR QNAME Total Enqueues Total Dequeues
PQM1 CUST.LOC 1000 1000
QMBK XML.PS.CS 800 1200
So i wrote my query like this
db2 => SELECT QMGR, QNAME, SUM(ENQ), SUM(DEQ) FROM DB2A.STAT GROUP BY QMGR, QNAME
it seams, it did not give me sum of ENQ, DEQ are correct.
Please correct me
Sorry, i guess it's working correct.
if you don't agree please let me know the correct one.