SELECT
emp_no,
COUNT(emp_no) t
FROM
salaries
GROUP BY
emp_no
HAVING
t > 15
牛客SQL练习-7-查找薪水变动超过15次的员工号emp_no以及其对应的变动次数t
最新推荐文章于 2021-06-30 16:24:15 发布
SELECT
emp_no,
COUNT(emp_no) t
FROM
salaries
GROUP BY
emp_no
HAVING
t > 15