This Leetcode problem Nth Highest Salary LeetCode Solution is done in SQL.
List of all LeetCode Solution
![Nth Highest Salary LeetCode Solution](https://i0.wp.com/totheinnovation.com/wp-content/uploads/2024/02/LeetCode-Problem-Solution.png?resize=200%2C200&ssl=1)
Nth Highest Salary LeetCode Solution
Table of Contents
Problem Statement
Column Name | Type |
id | int |
salary | int |
Employee
id is the primary key (column with unique values) for this table.
Each row of this table contains information about the salary of an employee.
Write a solution to find the nth
highest salary from the Employee
table. If there is no nth
highest salary, return null
.
The result format is in the following example.
Example 1:
Input:
id | salary |
1 | 100 |
2 | 200 |
3 | 300 |
Output:
getNthHighestSalary(2) |
200 |
Example 2:
Input:
id | salary |
1 | 100 |
Output:
getNthHighestSalary(2) |
null |
Nth Highest Salary LeetCode Solution MySQL
CREATE FUNCTION getNthHighestSalary(N INT) RETURNS INT BEGIN declare M INT;
set
M = N - 1;
RETURN (
# Write your MySQL query statement below.
select
distinct Salary
from
Employee
order by
Salary desc
limit
1 offset M
);
END
Code language: SQL (Structured Query Language) (sql)