[LeetCode] Nth Highest Salary, solution report, leetcodenth

[LeetCode] Nth Highest Salary, solution report, leetcodenth
Question

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 shocould return null.

Ideas

This question is given to the Employee table, asking to find the number of higher n wages.

We can use the order by and limit keywords to solve the Sorting Problem.

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