leecode
# leecode
问道于旁
江湖易老,岁月难催,且行且珍惜!
展开
-
leecode_CN#178:分数排名
#178难度:中等知识点:分组、行号、排序、整型转化、临时表、赋值、比较--1 我自己写的:以为会很慢,结果看着还好,87%select ss.Score AS SCore, temp.num AS Rankfrom Scores ssleft join ( select a.Score,Cast(@i := @i + 1 AS SIGNED) AS num f...原创 2019-12-03 23:59:36 · 144 阅读 · 0 评论 -
leecode_CN#177:第N高的薪水
#177中等考察点:PROC、if、176升级版、语法总结:语法不熟悉,吃亏138msCREATE FUNCTION getNthHighestSalary(N INT) RETURNS INTBEGIN DECLARE P INT ; IF(N<=0) THEN set P=0; else set P=N-1; ...原创 2019-12-03 23:21:24 · 138 阅读 · 0 评论 -
leecode_CN#175:组合2个表
#175类型:sql简单考察点:join、outer join、有效数据。select A.FirstName, A.LastName, B.City, B.Statefrom Person Aleft join (select distinct PersonId, City, State from Address) Bon A.PersonId=B.PersonId;总结:...原创 2019-12-03 22:54:13 · 111 阅读 · 0 评论 -
leecode_CN#176:第二高的薪水
分析类型:mysql考察点:去重、排序、筛选、空值判定、别名176 link解答:123 msselect IFNULL((select DISTINCT Salary from Employee order by Salary DESC limit 1,1), NULL) AS SecondHighestSalary扩展1:mysql 二者语法区别:limit 2,1...原创 2019-12-03 22:33:45 · 106 阅读 · 0 评论