MySQL
qq_38959715
这个作者很懒,什么都没留下…
展开
-
MySQL/175. Combine Two Tables 组合两个表
题目 代码部分一(260ms 89.84%)# Write your MySQL query statement belowSELECT p.FirstName,p.LastName,a.City,a.State FROM Person p LEFT JOIN Address a ON p.PersonId = a.PersonId ...转载 2018-10-13 11:21:20 · 944 阅读 · 0 评论 -
MySQL/184. Department Highest Salary 部门最高工资的员工
题目 代码部分一(1268ms)SELECT D.Name AS Department,E.Name AS Employee,E.Salary FROM Employee E,Department D WHERE E.DepartmentId=D.Id AND E.Salary IN( SELECT MAX(e.Sa...转载 2019-01-21 15:43:40 · 1130 阅读 · 0 评论 -
MySQL/185. Department Top Three Salaries 部门工资前三高的员工
题目 代码部分一(1423ms)SELECT d.Name AS Department,e1.Name AS Employee,e1.Salary AS Salary FROM Employee e1,Department d WHERE d.id=e1.DepartmentId AND ( SELECT COUNT(...转载 2019-01-25 23:08:41 · 1188 阅读 · 0 评论 -
601. Human Traffic of Stadium 体育馆的人流量
题目 代码部分一(545ms)SELECT s.* FROM( SELECT s1.* FROM stadium s1 JOIN stadium s2 ON s2.id=s1.id+1 JOIN stadium s3 ON s3.id=s2.id+1 WH...转载 2019-01-25 22:43:57 · 1079 阅读 · 0 评论 -
MySQL/180. Consecutive Numbers 连续出现的数字
题目 代码部分一(670ms)SELECT DISTINCT l1.Num AS ConsecutiveNums FROM Logs l1 JOIN Logs l2 ON l1.id=l2.id-1 JOIN Logs l3 ON l2.id=l3.id-1 WHERE l1.Num=l2.Num AND l2.Num=l3...转载 2019-01-19 15:24:57 · 1317 阅读 · 0 评论 -
MySQL/178. Rank Scores 分数排名
题目 代码部分一(1537ms)SELECT Score,(SELECT COUNT(DISTINCT Score) FROM Scores s2 WHERE s2.Score>=s1.Score) AS Rank FROM Scores s1 ORDER BY Rank 代码部分二(910ms)SELECT ...转载 2019-01-19 10:50:47 · 792 阅读 · 0 评论 -
Java/626. Exchange Seats 换座位
题目 代码部分一(577ms)SELECT(CASE WHEN MOD(id,2)!=0 AND id!=counts THEN id+1 WHEN MOD(id,2)!=0 AND id=counts THEN id ELSE id-1 END)AS id,student FROM sea...转载 2019-01-19 00:07:12 · 607 阅读 · 0 评论 -
MySQL/181. Employees Earning More Than Their Managers 超过经理收入的员工
题目 代码部分一(1936ms)SELECt a.Name AS Employee FROM Employee a WHERE a.Salary>( SELECT b.Salary FROM Employee b ...转载 2019-01-18 22:36:05 · 1008 阅读 · 0 评论 -
MySQL/176. Second Highest Salary 第二高的薪水
题目 代码部分一(1095ms)SELECT MAX(Salary) AS SecondHighestSalary FROM Employee E1 WHERE 1=(SELECT COUNT(DISTINCT(E2.Salary)) FROM Employee E2 WHERE E2.Salary>E1.Salary); 代...转载 2019-01-18 17:46:54 · 1000 阅读 · 0 评论 -
MySQL/596. Classes More Than 5 Students 超过5名学生的课
题目 代码部分(2002ms)SELECT class FROM courses GROUP BY class HAVING COUNT(DISTINCT student)>=5;转载 2019-01-18 16:03:25 · 985 阅读 · 0 评论 -
MySQL/197. Rising Temperature 上升的温度
题目 代码部分一(710ms)SELECT a.Id FROM Weather a, Weather b WHERE TO_DAYS(a.RecordDate) = TO_DAYS(b.RecordDate) + 1 AND a.Temperature > b.Temperature; 代码部分二(526ms)#...转载 2019-01-18 11:01:48 · 1012 阅读 · 0 评论 -
MySQL/196. Delete Duplicate Emails 删除重复的电子邮箱
题目 代码部分一(1433ms 50.12%)# Write your MySQL query statement belowDELETE a FROM Person a,Person b WHERE a.Email=b.Email AND a.Id>b.Id; 代码部分二(933ms 90.55%)# Writ...转载 2019-01-18 10:11:24 · 969 阅读 · 0 评论 -
MySQL/183. Customers Who Never Order 从不订购的客户
题目 代码部分一(869ms 29.11%)SELECT Name AS Customers FROM Customers LEFT JOIN Orders ON Customers.Id=Orders.CustomerId WHERE Orders.CustomerId IS NULL; 代码部分二(683ms 38.61...转载 2018-11-25 10:10:09 · 872 阅读 · 0 评论 -
MySQL/182. Duplicate Email 寻找重复的邮箱
题目 代码部分一SELECT Email from Person group by Email having count(Email)>1转载 2018-10-13 13:18:10 · 939 阅读 · 0 评论 -
MySQL/620. Not Boring Movies 有趣的电影
题目、 代码部分一(226ms 89.61%)SELECT id,movie,description,rating FROM cinema WHERE id%2!=0 AND description!='boring' ORDER BY rating DESC 代码部分二(1184ms 94.5...转载 2018-10-13 12:18:55 · 719 阅读 · 0 评论 -
MySQL/627. Swap Salary 交换工资
题目 代码部分UPDATE salary SET sex=IF(sex='f','m','f');转载 2018-10-13 12:06:11 · 714 阅读 · 0 评论 -
MySQL/595. Big Contries 大的国家
题目 代码部分一(4407ms)SELECT name,population,area FROM world WHERE area>3000000UNION SELECT name,population,area FROM world WHERE population>25000000;...转载 2018-10-13 11:53:55 · 637 阅读 · 0 评论 -
SQL 面试内容
现有两张表,Table A 是左边的表。Table B 是右边的表。其各有四条记录,其中有两条记录name是相同的:1. INNER JOIN 产生的结果是AB的交集SELECT * FROM TableA INNER JOIN TableB ON TableA.name = TableB.name2.LEFT [OUTER] JOIN 产生表A的完全集,而B表中匹配的则有值,没有匹配...转载 2019-03-13 14:22:06 · 1068 阅读 · 0 评论