leetcode学习记录
KSHATR1YA
菜鸟入门。路漫漫其修远兮~
展开
-
【leetcode】:175. 组合两个表
答案代码:SELECT a.FirstName, a.LastName, b.City, b.StateFROM Person a LEFT JOIN Address b ON a.personId = b.personId————————————————————————————分析:1)LEFT JOIN或LEFT OUTER JOIN 左连接左向外联接...原创 2018-06-13 16:59:08 · 270 阅读 · 0 评论 -
【leetcode】178. 分数排名
Create table If Not Exists Scores (Id int, Score DECIMAL(3,2))Truncate table Scoresinsert into Scores (Id, Score) values ('1', '3.5')insert into Scores (Id, Score) values ('2', '3.65')insert in...原创 2018-08-13 17:11:24 · 516 阅读 · 0 评论 -
【leetcode】626. 换座位
题目:小美是一所中学的信息科技老师,她有一张 seat 座位表,平时用来储存学生名字和与他们相对应的座位 id。其中纵列的 id 是连续递增的小美想改变相邻俩学生的座位。你能不能帮她写一个 SQL query 来输出小美想要的结果呢?答案:# Write your MySQL query statement belowselect s.id , s.student from(select i...原创 2018-07-02 17:42:45 · 685 阅读 · 0 评论 -
【leetcode】596. 超过5名学生的课
题目:答案:# Write your MySQL query statement belowselect classfromcoursesgroup by classhaving count(DISTINCT student) >= 5;原创 2018-07-02 17:24:57 · 387 阅读 · 0 评论 -
【leetcode】197. 上升的温度
题目:答案一:select w1.Id from weather w1inner join weather w2 on w1.Temperature > w2.Temperature and DATEDIFF(w1.RecordDate, w2.RecordDate)答案二:SELECT w1.Id FROM Weather w1, Weather w2WHERE w1.Temperat...原创 2018-07-02 17:10:37 · 316 阅读 · 0 评论 -
【leetcode】196. 删除重复的电子邮箱
题目:答案:# Write your MySQL query statement belowDELETE b FROM Person a, Person bWHERE a.Email = b.Email AND b.Id > a.Id;原创 2018-07-02 17:02:56 · 650 阅读 · 0 评论 -
【leetcode】183. 从不订购的客户
题目:答案:# Write your MySQL query statement belowselectc.Name CustomersfromCustomers c left join Orders o on c.Id = o.CustomerIdwhereo.CustomerId is null原创 2018-06-19 23:05:59 · 273 阅读 · 0 评论 -
【leetcode】595. 大的国家
题目:答案:# Write your MySQL query statement belowselectname,population,areafromWorldwherearea >= 3000000orpopulation >= 25000000这题大意了没仔细看题目是或。惭愧惭愧。...原创 2018-06-15 14:08:55 · 1861 阅读 · 0 评论 -
【leetcode】51. N皇后
题目:回想起来8皇后问题是当时算法课考试的最后一题,看分数的话这题当时应该是写错了不得分。答案:惭愧,还是没能写出来对的答案,只是大致知道用回溯法,编程能力还是不够。答案转自:https://blog.csdn.net/xygy8860/article/details/46861381 public class Solution { /** * 这题的...原创 2018-06-14 14:57:14 · 330 阅读 · 0 评论 -
【leetcode】181. 超过经理收入的员工
题目:答案:# Write your MySQL query statement belowselect a.Name as Employee from Employee a join Employee b on a.ManagerId = b.Id and a.Salary > b.Salary原创 2018-06-13 17:06:48 · 406 阅读 · 0 评论 -
【leetcode】176. 第二高的薪水
题目:答案:1# Write your MySQL query statement below select IFNULL((select Distinct Salary from Employee order by Salary DESC limit 1,1),null) as SecondHighestSalary 2# Write your MySQL query statement b...原创 2018-06-13 16:59:29 · 266 阅读 · 0 评论 -
【leetcode】177. 第N高的薪水
CREATE FUNCTION getNthHighestSalary(N INT) RETURNS INTBEGIN RETURN ( # Write your MySQL query statement below. select Max(Salary) from Employee e1 where N = ( select count(dis...原创 2018-08-13 17:27:29 · 254 阅读 · 0 评论