对同一查询中的SQL查询结果求和

用户名

我试图将第三列中两列的结果求和

SELECT A.Date, A.EmpID,
SUM(CASE WHEN State = 'active' THEN A.MinutesatState ELSE 0 END) AS active, 
SUM(CASE WHEN State = 'idle' THEN A.MinutesatState ELSE 0 END) AS idle,

FROM time A join ttld.login B on A.EmpID=B.username 
WHERE DATE = '01-15-2019' GROUP BY A.EmpID

第三列应该是我在查询中尝试过的活动和空闲数字的总和，但是由于我几乎不了解，我无法运行它

SELECT A.Date, A.EmpID,
SUM(CASE WHEN State = 'active' THEN A.MinutesatState ELSE 0 END) AS active, 
SUM(CASE WHEN State = 'idle' THEN A.MinutesatState ELSE 0 END) AS idle,

SUM(CASE WHEN State = ('idle','active') THEN A.MinutesatState ELSE 0 END) AS Total_of_active_and_Idle

FROM time A join ttld.login B on A.EmpID=B.username 
WHERE DATE = '01-15-2019' GROUP BY A.EmpID

法米

您可以在下面尝试-您需要添加（“空闲”，“活动”）

SELECT A.Date, A.EmpID,
SUM(CASE WHEN State = 'active' THEN A.MinutesatState ELSE 0 END) AS active, 
SUM(CASE WHEN State = 'idle' THEN A.MinutesatState ELSE 0 END) AS idle,

SUM(CASE WHEN State in ('idle','active') THEN A.MinutesatState ELSE 0 END) AS Total_of_active_and_Idle

FROM time A join ttld.login B on A.EmpID=B.username 
WHERE DATE = '01-15-2019' GROUP BY A.EmpID,A.Date

本文收集自互联网，转载请注明来源。

如有侵权，请联系 [email protected] 删除。