sql - 总结数字

Question

你好想知道如何使用 PostgreSQL 求和()“CALL ID 计数”，然后将结果放在列表的底部。我试过 union 和 group by。

AGENT   CALL ID count
xxxxx   13
xxxxx   21
xxxxx   49
xxxxx   58
xxxxx   67
xxxxx   32
xxxxx   9
xxxxx   8
xxxxx   39
xxxxx   1047

说

AGENT   CALL ID count
xxxxx   13
xxxxx   21
xxxxx   49
xxxxx   58
xxxxx   67
xxxxx   32
xxxxx   9
xxxxx   8
xxxxx   39
xxxxx   1047
TOTAL   1343

Select Agent,Sum("CALL ID count") as TOTAL 
from AgentCount 
group by "CALL ID count" 
order by Agent

我希望通过计数获得代理名称，然后在末尾获得总数谢谢

Answer 1

您必须使用 UNION 来合并两个查询，然后相应地使用 ORDER BY，请看下面的示例:

Select Agent,Sum("CALL ID count") as TOTAL 
from AgentCount 
group by Agent 
UNION
Select 'TOTAL' AS Agent ,Sum("CALL ID count") as TOTAL FROM AgentCount 
ORDER BY CASE WHEN Agent = 'TOTAL' THEN 1 ELSE 0 END ASC, Agent