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 · 546 阅读 · 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 · 293 阅读 · 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 · 176 阅读 · 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 · 207 阅读 · 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 · 164 阅读 · 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 · 138 阅读 · 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 · 323 阅读 · 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 · 168 阅读 · 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 · 224 阅读 · 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 · 169 阅读 · 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 · 157 阅读 · 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 · 244 阅读 · 0 评论