-- 题目提炼: 薪水记录 超过15条的员工 SELECT emp_no ,COUNT(emp_no) AS t FROM salaries GROUP BY emp_no HAVING t > 15 ;
分组------COUNT()计算-------HAVING条件
END
-- 题目提炼: 薪水记录 超过15条的员工 SELECT emp_no ,COUNT(emp_no) AS t FROM salaries GROUP BY emp_no HAVING t > 15 ;
分组------COUNT()计算-------HAVING条件
END