求总汇总信息
各位大侠:
我通过这个语句select b.workflow,count(b.batchname) BatchNum,sum(b.imagecount) ImageNum from (select a.batchname,a.workflow,a.imagecount from dbo.tbl_BatchesLog a join dbo.tb1_StatusInfo b on a.status=b.status) b group by b.workflow order by b.workflow
得到如下信息;
Workflow BatchNum ImageNum
Arbiter 19 5592
Audit 4 12
Batch_QC|Audit010 2 4
Check 6780 240962
Check|Audit 3966 213733
Check|Audit005 1308 13174
Check|Audit010 369 3390
DbKey|Arbiter|ReArbiter 447 20300
DbKey|Arbiter|ReArbiter|Audit 3460 153845
DbKey|Arbiter|ReArbiter|Audit005 88 4186
DbKey|Arbiter|ReArbiter|Audit010 1374 120001
Key 1169 24504
Key|Audit 1955 30574
Key|Audit005 1749 27928
Key|Audit010 670 5437
Key|Audit050 1 4
Key|Audit100 3 22
Key|Check|Audit 113 333
Key|Check|Audit005 3 3
Key|Check|Audit010 563 1408
MK_Scheme 1 10
我应该如何在对batchnum,imagenum计算总的数目,即total: batchnum总数目,imagenum总数目,加到后面显示。