文章目录
一、 查找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都不会写,赶快去学习吧!!!
🤦♀️🤦♀️🤦♀️