力扣MySQL
凡我出品,皆属精品
这个作者很懒,什么都没留下…
展开
-
#力扣MySQL 1179. 重新格式化部门表 @FDDLC
题目描述: 1179. 重新格式化部门表 - 力扣(LeetCode) (leetcode-cn.com) select id, sum(case when month='Jan' then revenue end) Jan_Revenue, sum(case when month='Feb' then revenue end) Feb_Revenue, sum(case when month='Mar' then revenue end) Mar_Revenue, sum(case when .原创 2021-05-18 20:47:25 · 141 阅读 · 0 评论 -
#力扣 MySQL196. 删除重复的电子邮箱 @FDDLC
题目描述: 196. 删除重复的电子邮箱 - 力扣(LeetCode) (leetcode-cn.com) SQL: delete from Person where Id not in( select * from (select min(Id) from Person group by Email) t ) 注:下面的写法MySQL不支持,但SQLServer支持! delete from Person where Id not in (select min(Id) .原创 2021-05-18 19:30:39 · 179 阅读 · 0 评论 -
#力扣 MySQL:183. 从不订购的客户 @FDDLC
题目描述: 183. 从不订购的客户 - 力扣(LeetCode) (leetcode-cn.com) SQL: select Name Customers from Customers where id not in (select CustomerId from Orders) SQL2: select Name Customers from Customers c left join Orders o on c.Id=o.CustomerId where o.Customer..原创 2021-05-18 15:23:41 · 128 阅读 · 0 评论 -
#力扣 MySQL181. 超过经理收入的员工 @FDDLC
题目描述: 181. 超过经理收入的员工 - 力扣(LeetCode) (leetcode-cn.com) SQL: select e.Name Employee from Employee e,Employee m where e.ManagerId=m.Id and e.Salary>m.Salary;原创 2021-05-17 00:10:41 · 121 阅读 · 0 评论 -
#力扣MySQL:175. 组合两个表 @FDDLC
175. 组合两个表 - 力扣(LeetCode) (leetcode-cn.com) select FirstName,LastName,City,State from Person left outer join Address on Person.PersonId=Address.PersonId;原创 2021-05-16 23:50:53 · 139 阅读 · 0 评论 -
#力扣 LeetCode MySQL:182. 查找重复的电子邮箱 @FDDLC
题目描述: 182. 查找重复的电子邮箱 - 力扣(LeetCode) (leetcode-cn.com) SQL: # Write your MySQL query statement below select Email from Person group by Email having count(Email)>1原创 2021-05-16 23:36:48 · 212 阅读 · 0 评论