Leetcode - Database
Leetcode上关于database的题solution以及知识点
洛yu
数据分析行业,编程小白,主要用R,Python,博客纯粹为了记录自己的学习笔记
展开
-
Leetcode_Database-176. Second Highest Salary
#Leetcode Database176. Second Highest SalaryURL:https://leetcode.com/problems/second-highest-salary/Solution:Select (Select DISTINCT Salary From Employee order by Salary desc limit 1 Offset 1) AS SecondHighestSalaryNote:limit n1offset ...原创 2020-11-17 09:53:46 · 82 阅读 · 0 评论 -
Leetcode_Database-177. Nth Highest Salary
#Leetcode Database177.Nth Highest SalaryURL:https://leetcode.com/problems/nth-highest-salary/这个题跟176. Second Highest Salary 方法类似,只是将查询过程写到了一个函数中,用了 CREATE FUNCTION【Solution 1】:CREATE FUNCTION getNthHighestSalary(N INT) RETURNS INTBEGIN D...原创 2020-11-17 13:10:40 · 88 阅读 · 0 评论 -
Leetcode_Database-178. Rank Scores
#Leetcode Database178. Rank ScoresURL:https://leetcode.com/problems/rank-scores/这个题比较简单,跟176、177题类似。但是提交之后 Runtime:486 ms, faster than17.71%ofMySQLonline submissions forRank Scores.应该有更高效的方法。Solution:SELECT Score, DENSE_RANK() OVER(ORDER...原创 2020-11-17 14:12:28 · 100 阅读 · 0 评论