我一直在寻找以下问题的答案,但尚未成功。我正在尝试计算特定部门内用户达到某个级别的次数。
经过多次尝试,我设法从下面的查询中获得结果,但是结果不在所需的时间戳值之间,而是显示了 LEVEL 的总数。时间戳是表中列的名称,这可能是一个问题吗?
SELECT COUNT(LEVEL) AS number, LEVEL, user, department FROM table
WHERE LEVEL ='3' AND TIMESTAMP>= '1500098552' AND TIMESTAMP<= '1568000152'
GROUP BY user ORDER BY number DESC
我曾尝试对 WHERE 子句使用各种方法,包括 BETWEEN 但无济于事。
任何建议将不胜感激,谢谢。
试试这个
SELECT COUNT(LEVEL) AS number, LEVEL, user, department FROM table
WHERE LEVEL ='3' AND TIMESTAMP>= 1500098552 AND TIMESTAMP<= 1568000152
GROUP BY user,department,LEVEL ORDER BY number DESC
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句