Skip to content
Programming101
Programmingoneonone
  • Home
  • CS Subjects
    • Internet of Things (IoT)
    • 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
Programmingoneonone

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 solutions

Post navigation

Previous post
Next post

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
  • YouTube
  • LinkedIn
  • Facebook
  • Pinterest
  • Instagram
©2025 Programmingoneonone | WordPress Theme by SuperbThemes