sql 分类

借方科目          贷方科目                    金额
1001000000 1405002000  1.000000000
1001000000 1405002000  2.000000000
1001000000 1405002000  3.000000000
1002003001 1012000000  4.000000000
1002003001 1012000000  5.000000000
1002003001 1012000000  1.000000000
变成：

       科目            借方金额       贷方金额      
1001000000               6             0
1002003001               10            0
1405002000               0             6      
1012000000               0             10

 

 

select debit as '科目代码' , sum(pay) '借方金额' ,0 '贷方金额'  from zkmcAnalytical group by  debit

union all
select lenders , 0 , sum(pay) from zkmcAnalytical group by  lenders