我想从表中计算值Chat
:
ID REASON_ID DEPARTMENT_ID
1 46 1
2 46 1
3 50 1
4 50 2
5 100 1
6 100 2
这些存在于Reason
表中:
ID REASON_NAME
46 Reason1
50 Reason2
100 Reason3
在哪里DEPARTMENT_ID=1
,我想要这样的结果:
ID46 ID50 ID100
2 1 1
我该怎么做?
动态SQL解决方案更好,但是如果您需要其他选择:
SELECT SUM(I46) ID46,
SUM(I50) ID50,
SUM(I100) ID100
FROM
(SELECT
COUNT(CASE WHEN reason_id = 46 THEN 1 END) I46,
COUNT(CASE WHEN reason_id = 50 THEN 1 END) I50,
COUNT(CASE WHEN reason_id = 100 THEN 1 END) I100
FROM chat
WHERE department_id = 1
GROUP BY reason_id) q1;
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句