4条回答
- Tiger_Zhao 2015-08-18 05:31关注
SQL Server
/* 测试数据 WITH table1(运单明细,运单编号,付款方式,运费)AS( SELECT 'L11','Y05',1,30 UNION ALL SELECT 'L12','Y05',2,40 UNION ALL SELECT 'L13','Y05',2,30 UNION ALL SELECT 'L14','Y06',1,50 UNION ALL SELECT 'L15','Y06',1,60 UNION ALL SELECT 'L16','Y06',2,40 ) */ SELECT 运单编号, [1] AS 付款方式1的运费合计, [2] AS 付款方式2的运费合计, [1]+[2] AS 全部运费合计 FROM ( SELECT 运单编号,付款方式,运费 FROM table1 ) t PIVOT ( SUM(运费) FOR 付款方式 IN ([1],[2]) ) p
结果
运单编号 付款方式1的运费合计 付款方式2的运费合计 全部运费合计 -------- ------------------- ------------------- ------------ Y05 30 70 100 Y06 110 40 150
本回答被题主选为最佳回答 , 对您是否有帮助呢?解决 无用评论 打赏 举报