Skip to content
Programmingoneonone
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
Programmingoneonone

Leetcode Second Highest Salary problem solution

YASH PAL, 31 July 2024

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

Leetcode Second Highest Salary problem solution

MYSQL solution.

select MAX(Salary) as "SecondHighestSalary"
from Employee
where Salary < (select MAX(Salary) from Employee);

TSQL solution.

SELECT
ISNULL((SELECT DISTINCT Salary as Salary
FROM Employee
ORDER BY Salary DESC OFFSET 1 ROWS FETCH NEXT 1 ROW ONLY), NULL)
AS SecondHighestSalary

Second MYSQL solution.

SELECT MAX(Salary) AS SecondHighestSalary
FROM Employee
WHERE Salary!=(SELECT MAX(Salary)FROM Employee)

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