Question

如何用sql语句查询按月计算员工业绩的结果：

表usercj数据 ：
id， uesrid， yue， cj
1 001 1 50.0
2 001 2 60.0
3 001 3 70.0
4 002 1 65.0
5 002 2 78.0
6 002 3 64.0
7 003 1 55.0
8 003 2 62.0
9 003 3 81.0
我想得到按月计算员工的总成绩，像这样的结果：
userid sumcj
001 180
002 207
003 198
请高手告知

Answer 1

SELECT userid,
SUM(cj) as suncj
FROM Table_Text
GROUP BY userid

Answer 2

"SELECT userid,SUM(cj) as sumcj FROM usercj GROUP BY userid"

Answer 3

SELECT userid
SUM(cj)
FROM usercj
GROUP BY userid