有表1数据如下:
ID,DWDM,DWMC,JYM,ZJXZ,ZFFS,JE,ZY
01,1001,单位一,DWY,01,02,1580.00,购买软件
02,1001,单位一,DWY,02,02,4850.00,发放工资
03,1001,单位一,DWY,01,02,1000.00,奖金
04,1002,单位二,DWE,02,02,44850.00,工资
05,1002,单位二,DWE,01,02,1600.00,奖金
现在我想用一条语句就能列出如下结果:
1001,单位一,DWY,01,02,2580.00
1001,单位一,DWY,02,02,4850.00
合计,单位一,7430.00
1002,单位二,DWE,02,02,44850.00
1002,单位二,DWE,01,02,1600.00
合计,单位二,46450.00
请高手帮忙下,我是想在通过一条SQL语句显示如上结果,谢谢!
|