考察group by 和 having 搭配使用 默认的情况下 where后的过滤条件优先与Having
select emp_no,count(*) salary from salaries GROUP by emp_no having count(*)>15
考察group by 和 having 搭配使用 默认的情况下 where后的过滤条件优先与Having
select emp_no,count(*) salary from salaries GROUP by emp_no having count(*)>15