使用窗口函数COUNT() OVER (PARTITION BY)
SELECT DISTINCT emp_no, t FROM ( SELECT *, COUNT(emp_no) OVER (PARTITION BY emp_no) AS t FROM salaries) AS selected_salaries WHERE t > 15;
SELECT DISTINCT emp_no, t FROM ( SELECT *, COUNT(emp_no) OVER (PARTITION BY emp_no) AS t FROM salaries) AS selected_salaries WHERE t > 15;