【SQL】刷题整理[二]

一、 查找employees表emp_no与last_name的员工信息

代码如下：

select * from employees
where emp_no%2 =1 and last_name!="Mary"
order by hire_date desc;

二、获取当前薪水第二多的员工的emp_no以及其对应的薪水salary

代码如下：

select emp_no,salary from salaries
order by salary desc
limit 1,1;

三、力扣596. 超过五名学生的课

代码如下：

select class from courses
group by class
having count(distinct student) >= 5;

四、力扣182. 查找重复的电子邮箱

代码如下：

select Email
from Person
group by Email
having count(Email) > 1;

五、力扣196. 删除重复的电子邮箱

代码如下：

delete a
from person as a inner join person as b
where a.email = b.email and a.id > b.id

旺财菜的简单的SQL都不会写，赶快去学习吧！！！
🤦‍♀️🤦‍♀️🤦‍♀️