SqlServer_select-多次sum查询结果合并;
来源:互联网 发布:网络新骗局 编辑:程序博客网 时间:2024/05/21 17:13
=>背景介绍
->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
->如何获得销售员13、14年的销售总额?
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
B最后,通过fredrickhu版主大大的指点,修改如下:
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大大!谢谢!..风雨兼程...
- SqlServer_select-多次sum查询结果合并;
- SqlServer_select-多次sum查询结果合并;
- 合并查询数据结果
- ORACLE-合并查询结果
- mysql查询结果合并
- mysql合并查询结果
- 横向合并查询结果
- mysql查询结果合并
- mysql合并查询结果
- union合并查询结果
- 多次查询以及查询的合并
- SQL如何合并查询结果
- union(联合)合并查询结果
- oracle的查询结果合并
- mysql 合并两个查询结果
- MYSQL之合并查询结果
- sql语句查询结果合并unionall用法
- sql查询结果合并(union)
- 关于Spring AOP无法嵌套拦截
- [kruskal]poj 1251
- MAC MYSQL ERROR 1044 (42000)
- spoj 4053 动态规划
- strlen和sizeof的区别
- SqlServer_select-多次sum查询结果合并;
- Struts2.3.16.1+Hibernate4.3.4+Spring4.0.2 框架整合
- 《转》 JS 用window.open()函数,父级页面如何取到子级页面的返回值?
- 最小生成树(prime算法、kruskal算法) 和 最短路径算法(floyd、dijkstra)
- 最小生成树
- 发个从前的游戏开发习作(SRPG,仅支持Android)
- C语言怎么使用EOF
- P1007绕钉子的长绳子
- PowerPoint教程资源专题资源免费下载整理合集收藏