在線等待高手的答復:分類求和用sql實現: 表tb1
in_date prd_no type rank qty qty2

01-01-2006 pd-01 mk-01 mr-01 50 60

01-01-2006 pd-01 mk-01 mr-02 80 90

01-01-2006 pd-01 mk-02 mr-01 100 150

01-01-2006 pd-01 mk-02 mr-02 120 100

01-02-2006 pd-01 mk-01 mr-01 60 60

01-02-2006 pd-01 mk-01 mr-02 90 70

01-02-2006 pd-01 mk-02 mr-01 140 120

01-02-2006 pd-01 mk-02 mr-02 180 100

要求得到的結果為﹕

in_date prd_no type rank qty1 qty2

01-01-2006 pd-01 mk-01 mr-01 50 60

mk-01 mr-02 80 90

mk-02 mr-01 100 150

mk-02 mr-02 120 100

mk-01 mr-01 60 60

mk-01 mr-02 90 70

mk-02 mr-01 140 120

mk-02 mr-02 180 100

小計 mk-01 mr-01 110 120

mr-02 170 160

mk-02 mr-01 240 270

mr-02 300 200

合計﹕ mk-01 mr-01 230

mr-02 330

mk-02 mr-01 510

mr-02 500

参照SQL中的DISTINCT,去掉重复记录

select '小计', '', type, rank, sum(qty) as qty, sum(qty2) as qty2 from tb1 group by type, rank order by type, rank into cursor tb2
select '合计', '', type, rank, 0, (qty+qty2) as qty2 from tb2 order by type, rank into cursor tb3

把tb1, tb2, tb3 合并到一个表里，在报表打印时不打印 in_date, prd_no, type, rank 的重复行即可