Last updated on October 9th, 2024 at 10:45 pm

This Leetcode problem Nth Highest Salary LeetCode Solution is done in SQL.

List of all LeetCode Solution

Nth Highest Salary LeetCode Solution

Problem Statement

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:

Output:

Example 2:
Input:

Output:

1. 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