同一张表用不同的查询条件分别得到5个值，将数据拼接。

熙舞安

于 2020-03-09 18:26:57 发布

阅读量654

点赞数 1

本文链接：https://blog.youkuaiyun.com/xuanbabyliu/article/details/104758254

版权

SELECT
(SELECT SUM(OrderMoney) FROM T_Cloud_Agent_Customer_Contract WHERE relatedStatus = 1 AND YEAR(AddDate)=2020 and MONTH(AddDate)=1) as allMaketMoney,
(SELECT SUM(OrderMoney) FROM T_Cloud_Agent_Customer_Contract WHERE relatedStatus = 1 AND Status = 0 AND YEAR(AddDate)=2020 AND MONTH(AddDate)=1) as waitConfirmMoney,
(SELECT SUM(OrderMoney) FROM T_Cloud_Agent_Customer_Contract WHERE relatedStatus = 1 AND Status = 1 AND YEAR(AddDate)=2020 AND MONTH(AddDate)=1) as confirmMoney,
(SELECT SUM(OrderMoney) FROM T_Cloud_Agent_Customer_Contract WHERE relatedStatus = 1 AND Status = 2 AND YEAR(AddDate)=2020 AND MONTH(AddDate)=1) as rejectMoney,
(SELECT SUM(OrderMoney) FROM T_Cloud_Agent_Customer_Contract WHERE relatedStatus = 0 AND YEAR(AddDate)=2020 AND MONTH(AddDate)=1) as noContractOrderCount
FROM DUAL