LeetCode Database
TarucaLiu
这个作者很懒,什么都没留下…
展开
-
181 Employees Earning More Than Their Managers
Solution#1# Write your MySQL query statement belowSELECT E.Name AS Employee FROM Employee AS E INNER JOIN Employee AS M ON E.ManagerId = M.Id WHERE E.Salary > M.SalaryProblem 1. 注意查询结果的表名原创 2017-03-01 11:32:55 · 542 阅读 · 0 评论 -
180. Consecutive Numbers(Done)
题目摘要 写一个SQL查询,用来寻找所有连续出现三次以上的Num Id Num 1 1 2 1 3 1 4 2 5 1 6 2 7 2例如,给定如上Logs表,返回1解法# Write your MySQL query statement belowSELECT distinct(l1.Num) AS ConsecutiveNu原创 2017-03-27 19:45:18 · 286 阅读 · 0 评论 -
182. Duplicate Emails#2
Solutin#1SELECT Email FROM (SELECT Email, COUNT(Email) AS Cnt FROM Person GROUP BY Email) T WHERE Cnt > 1Solutin#2()SELECT Email FROM Person GROUP BY Email HAVING COUNT(Email) > 1Problem 1. Mysql:Wi原创 2017-03-01 11:00:40 · 171 阅读 · 0 评论 -
178. Rank Scores#1
Solution#1# Write your MySQL query statement belowSELECT Score, (SELECT COUNT(DISTINCT Score) FROM Scores WHERE S.Score <= Score) Rank From Scores S ORDER BY Score DESCSolution#2# Write yo原创 2017-03-01 21:53:13 · 202 阅读 · 0 评论 -
196. Delete Duplicate Emails#1
Solution#1# Write your MySQL query statement belowDELETE p1FROM Person p1, Person p2 WHERE p1.Email = p2.EmailAND p1.Id > p2.IdSolution#2(更快)# Write your MySQL query statement belowDELETE FROM Pe原创 2017-03-01 21:25:44 · 161 阅读 · 0 评论 -
196. Delete Duplicate Emails#1
Solution#1# Write your MySQL query statement belowDELETE p1FROM Person p1, Person p2 WHERE p1.Email = p2.EmailAND p1.Id > p2.IdSolution#2(更快)# Write your MySQL query statement belowDELETE FROM Pe原创 2017-03-01 21:25:32 · 134 阅读 · 0 评论 -
196. Delete Duplicate Emails#1
Solution#1# Write your MySQL query statement belowDELETE p1FROM Person p1, Person p2 WHERE p1.Email = p2.EmailAND p1.Id > p2.IdSolution#2(更快)# Write your MySQL query statement belowDELETE FROM Pe原创 2017-03-01 21:25:29 · 314 阅读 · 0 评论 -
176. Second Highest Salary#1
Solutin#1# Write your MySQL query statement belowSELECT MAX(Salary) AS SecondHighestSalaryFROM EmployeeWHERE Salary < (SELECT MAX(Salary) FROM Employee)#Using max() will return a NULL #if the value原创 2017-03-01 20:32:53 · 163 阅读 · 0 评论 -
197. Rising Temperature#1
Solution#1# Write your MySQL query statement belowSELECT T.Id FROM Weather AS T INNER JOIN Weather AS Y ON T.Date = Y.Date + interval 1 dayAND T.Temperature > Y.Temperature;Problem#1 1. 题目没仔细思考,Id原创 2017-03-01 20:22:57 · 222 阅读 · 0 评论 -
175. Combine Two Tables
Solution#1# Write your MySQL query statement belowSELECT Name AS Customers FROM Customers WHERE Id NOT IN(SELECT CustomerId FROM Orders)原创 2017-03-01 17:35:57 · 166 阅读 · 0 评论 -
175. Combine Two Tables
Solution#1# Write your MySQL query statement belowSELECT P.FirstName, P.LastName, A.City, A.State From Person AS P LEFT JOIN Address AS A ON P.PersonId = A.PersonId原创 2017-03-01 11:33:51 · 152 阅读 · 0 评论 -
184. Department Highest Salary#1
题目摘要 选出每栋Department中薪水最高的人(每栋楼不知一个)解法 Solution1# Write your MySQL query statement belowSELECT d.Name AS Department, e.Name As Employee, e.SalaryFrom Employee AS eINNER JOIN ( SELECT max(Salary原创 2017-04-12 09:30:25 · 238 阅读 · 0 评论