SELECT job,sum(num) cnt FROM resume_info WHERE LEFT(date,4)='2025' GROUP BY job ORDER BY cnt DESC
1.先筛选再分组用WHERE
先分组再筛选用HAVING
2.难点在于2025的处理
这里用LEFT函数,最左边4个是2025就行
有没有其他方法?
SELECT job,sum(num) cnt FROM resume_info WHERE LEFT(date,4)='2025' GROUP BY job ORDER BY cnt DESC
1.先筛选再分组用WHERE
先分组再筛选用HAVING
2.难点在于2025的处理
这里用LEFT函数,最左边4个是2025就行
有没有其他方法?