SELECT * FROM ( SELECT emp_no, COUNT( emp_no ) AS t FROM salaries GROUP BY emp_no ) AS sal WHERE sal.t > 15; 根据emp_no分组形成emp_no和统计次数t的临时表，从临时表中查询出t>15的记录。