1、题目
查找薪水变动超过15次的员工号emp_no以及其对应的变动次数t
CREATE TABLE salaries
(
emp_no
int(11) NOT NULL,
salary
int(11) NOT NULL,
from_date
date NOT NULL,
to_date
date NOT NULL,
PRIMARY KEY (emp_no
,from_date
));
2、代码
代码一:子查询
select emp_no,cnt from (select emp_no,count(*) as cnt
from salaries
group by emp_no) as a
where cnt >15;
代码二:having
select emp_no,count(*) as cnt from salaries group by emp_no
having cnt >15;