177. Nth Highest Salary LeetCode Solution

In this guide, you will get 177. Nth Highest Salary LeetCode Solution with the best time and space complexity. The solution to Nth Highest Salary problem is provided in various programming languages like C++, Java, and Python. This will be helpful for you if you are preparing for placements, hackathons, interviews, or practice purposes. The solutions provided here are very easy to follow and include detailed explanations.

Problem Statement
Complexity Analysis
Nth Highest Salary solution in C++
Nth Highest Salary solution in Java
Nth Highest Salary solution in Python
Additional Resources

177. Nth Highest SalaryLeetCode Solution image

Problem Statement of Nth Highest Salary

Table: Employee

+————-+——+
| 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 not found

Constraints not found

Complexity Analysis

Time Complexity: Google AdSense
Space Complexity: Google Analytics

177. Nth Highest Salary LeetCode Solution in C++

CREATE FUNCTION getNthHighestSalary(N INT) RETURNS INT
BEGIN
  RETURN (
    WITH
      RankedEmployees AS (
        SELECT *, DENSE_RANK() OVER(ORDER BY salary DESC) AS `rank`
        FROM Employee
      )
    SELECT MAX(salary) AS SecondHighestSalary
    FROM RankedEmployees
    WHERE `rank` = N
  );
END
/* code provided by PROGIEZ */