表A
MK002(年), MK005(月), MK003(科目), MK004(部門), TB007(預算金額), MK006(發生金額), TOTAL(發生金額總額)
2014, 06, 660162, 206, 530, 0, 0
2014, 06, 660162, 206, 530, 22.82, 22.82
2014, 06, 660161, 206, 90, 0, 0
2014, 06, 660161, 206, 90, 0, 109652.00
2014, 06, 660160, 206, 100, 0, 0
求生成數據
MK002(年), MK005(月), MK003(科目), MK004(部門), TB007(預算金額), MK006(發生金額), TOTAL(發生金額總額)
2014, 06, 660162, 206, 530, 22.82, 22.82
2014, 06, 660161, 206, 90, 0, 109652.00
2014, 06, 660160, 206, 100, 0, 0
就是說
同年,同月份,同科目,同部門的只要一條記錄
謝謝
------解决方案--------------------
select MK002, MK005, MK003, MK004, max(TB007)TB007, max(MK006)MK006, max(TOTAL)TOTAL
from 表
group by MK002,MK005,MK003,MK004
------解决方案--------------------
select mk002,mk005,mk003,mk004,max(tb007),max(mk006),max(total)
from table_name
group by mk002,mk005,mk003,mk004