![](https://img-blog.csdnimg.cn/20201014180756928.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
刷题
文章平均质量分 50
sinat_41876868
这个作者很懒,什么都没留下…
展开
-
力扣197题. 上升的温度
selecta.idfromWeatherainnerjoinWeatherbondatediff(a.recordDate,b.recordDate)=1anda.Temperature>b.Temperature;datediff(a.recordDate,b.recordDate):返回两个日期的差值selecta.idfromWeatherainnerjoinWeatherbona.recordDate=ADDDATE(b.recordDa...原创 2021-12-24 03:55:45 · 321 阅读 · 0 评论 -
力扣185题: 部门工资前三高的所有员工
1、找出每个员工工资信息及部门信息,两个表连接即可:select * from Employee left join Department on employee.DepartmentId=Department.id2、步骤1的结果不符合题目要求,找出每个部门工资前三高的:select * from Employee left join Department on employee.DepartmentId=Department.id where (DepartmentId,salary...原创 2021-12-22 11:00:41 · 575 阅读 · 0 评论 -
力扣184题:部门工资最高的员工
1、先需找出每个员工工资信息及部门信息,两个表连接即可:select * from Employee left join Department on employee.DepartmentId=Department.id返回结果:{"headers": ["id", "name", "salary", "departmentId", "id", "name"], "values": [[1, "Joe", 70000, 1, 1, "IT"], [2, "Jim", 90000, 1, 1, "IT"原创 2021-12-22 00:55:29 · 638 阅读 · 0 评论