Last updated on March 10th, 2025 at 11:12 pm

Here, we see the Nth Highest Salary LeetCode Solution. This Leetcode problem is solved using MySQL and Pandas.

List of all LeetCode Solution

Level of Question

Medium

Nth Highest Salary LeetCode Solution

1. Problem Statement

Column Name	Type
id	int
salary	int

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

2. Code Implementation in Different Languages

2.1 Nth Highest Salary 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