SqlServer_select-多次sum查询结果合并；

=>背景介绍

->tableSales表

->第一次查询(2013销售员销售总额)

select salesName,sum(extendedPrice) as sumprice13 from tableSales where salesTime between '2013-01-01' and '2013-12-31' group by salesName

->第二次查询(2014销售员销售总额)

select? salesName,sum(extendedPrice) as sumprice14 from tableSales where salesTime between '2014-01-01' and '2014-12-31' group by salesName

A、首先，我想到的就是用union all，但不理想；

select salesName,sum(extendedPrice) as sumprice13,null as sumprice14 from tableSales where salesTime between '2013-01-01' and '2013-12-31' group by salesName
union all
select? salesName,null as sumprice13,sum(extendedPrice) as sumprice14 from tableSales where salesTime between '2014-01-01' and '2014-12-31' group by salesName

SELECT
??? a.salesName,a.sumprice13,b.sumprice14
FROM
??? (SELECT
??????? salesName,SUM(extendedPrice) AS sumprice13
???? FROM
??????? tableSales
???? WHERE
??????? salesTime BETWEEN '2013-01-01' AND '2013-12-31'
???? GROUP BY
??????? salesName
????? ) AS a
INNER JOIN
?? ? (SELECT
??????? salesName,SUM(extendedPrice) AS sumprice14
????? FROM
??????? tableSales
????? WHERE
??????? salesTime BETWEEN '2014-01-01' AND '2014-12-31'
????? GROUP BY
??????? salesName
????? ) AS b
ON a.salesName=b.salesName
?

最后再次感谢fredrickhu大大！谢谢！..风雨兼程...

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!