![](https://img-blog.csdnimg.cn/20201014180756925.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
leetcode(sql)
yuppie__1029
这个作者很懒,什么都没留下…
展开
-
181.超过经理收入的员工
Employee表包含所有员工,他们的经理也属于员工。每个员工都有一个 Id,此外还有一列对应员工的经理的 Id。+----+-------+--------+-----------+| Id | Name | Salary | ManagerId |+----+-------+--------+-----------+| 1 | Joe | 70000 | 3 ...原创 2020-04-28 20:58:44 · 65 阅读 · 0 评论 -
175.组合两个表
# Write your MySQL query statement belowselect Person.FirstName,Person.LastName,Address.City,Address.Statefrom Person left join Addresson Person.PersonId=Address.PersonId;原创 2020-04-27 18:02:07 · 64 阅读 · 0 评论 -
620.有趣的电影
# Write your MySQL query statement belowselect * from cinemawhere id%2!=0AND description !='boring'order by rating desc原创 2020-04-26 12:46:34 · 90 阅读 · 0 评论 -
627.交换工资
# Write your MySQL query statement belowupdate salary set sex=if(sex='m','f','m')原创 2020-04-25 14:58:51 · 157 阅读 · 0 评论 -
595.大的国家
# Write your MySQL query statement belowselect name,population,area from World where area>3000000 or population>25000000原创 2020-04-25 14:00:48 · 111 阅读 · 0 评论 -
182.查找重复的电子邮箱
代码:select Email from Person group by Email having count(Email)>1原创 2020-04-23 15:14:20 · 271 阅读 · 0 评论