Skip to content
Programming101
Programming101

Learn everything about programming

  • Home
  • CS Subjects
    • IoT – Internet of Things
    • Digital Communication
    • Human Values
  • Programming Tutorials
    • C Programming
    • Data structures and Algorithms
    • 100+ Java Programs
    • 100+ C Programs
  • HackerRank Solutions
    • HackerRank Algorithms Solutions
    • HackerRank C problems solutions
    • HackerRank C++ problems solutions
    • HackerRank Java problems solutions
    • HackerRank Python problems solutions
Programming101
Programming101

Learn everything about programming

Leetcode Nth Highest Salary problem solution

YASH PAL, 31 July 2024

In this Leetcode Nth Highest Salary problem solution, we need to write a SQL query to get the nth highest salary from the Employee table.

Leetcode Nth Highest Salary problem solution

MYSQL solution.

CREATE FUNCTION getNthHighestSalary(N INT) RETURNS INT
BEGIN
DECLARE M INT;
SET M = N-1;
RETURN (
SELECT IFNULL ((SELECT DISTINCT Salary FROM Employee order by Salary desc limit M,1), null)
as getNthHighestSalary

);
END

Postgre solution.

drop table if exists employee;
create table employee
(id int,
salary int);
insert into employee
values
	(1, 100),
	(2, 200),
	(3, 300);


create or replace function getnth(n int)
returns int as $ranks$
declare
	ranks int;
begin
	select salary into ranks from employee
	group by salary
	order by salary desc
	limit 1 offset n-1;
	return ranks;
end;
$ranks$ LANGUAGE plpgsql;
select getnth(3);

Oracle solution.

CREATE FUNCTION getNthHighestSalary(N IN NUMBER) RETURN NUMBER IS
result NUMBER;

BEGIN
    /* Write your PL/SQL query statement below */
    with a as (select salary, dense_rank() over (order by salary desc) as sal_rank from employee)
    select distinct salary into result from a where sal_rank = n;
    RETURN result;
END;

coding problems

Post navigation

Previous post
Next post
  • HackerRank Separate the Numbers solution
  • How AI Is Revolutionizing Personalized Learning in Schools
  • GTA 5 is the Game of the Year for 2024 and 2025
  • Hackerrank Day 5 loops 30 days of code solution
  • Hackerrank Day 6 Lets Review 30 days of code solution
How to download udemy paid courses for free

Pages

  • About US
  • Contact US
  • Privacy Policy

Programing Practice

  • C Programs
  • java Programs

HackerRank Solutions

  • C
  • C++
  • Java
  • Python
  • Algorithm

Other

  • Leetcode Solutions
  • Interview Preparation

Programming Tutorials

  • DSA
  • C

CS Subjects

  • Digital Communication
  • Human Values
  • Internet Of Things
©2025 Programming101 | WordPress Theme by SuperbThemes