[LeetCode]Nth Highest Salary,解題報告，leetcodenth

[LeetCode]Nth Highest Salary,解題報告，leetcodenth
題目

Write a SQL query to get the nth highest salary from the Employee table.

Id	Salary
1	100
2	200
3	300

For example, given the above Employee table, the nth highest salary where n = 2 is 200. If there is no nth highest salary, then the query should return null.

思路

這道題目給了Employee表，要求找到第n高的工資數目是多少。

排序的問題我們可以使用order by和limit兩個關鍵字來搞定。

AC SQL

CREATE FUNCTION getNthHighestSalary(N INT) RETURNS INTBEGINDECLARE M INT;SET M=N-1;  RETURN (        # Write your MySQL query statement below.        select distinct Salary from Employee order by Salary desc limit M, 1    );END