DDSA Solutions

176. Second Highest Salary

UnknownView on LeetCode
Database

Problem Overview

Second Highest Salary is a unknown-difficulty LeetCode problem. This is a common Database pattern in coding interviews. Study the solution below and note the time and space complexity before attempting variations on your own.

A full step-by-step explanation is being added. See the study guide for pattern-based practice.

Read the solution code below and trace through it on paper before submitting. For structured interview prep, follow our 30-day study guide.

176.sql
MySQL
/* Write your T-SQL query statement below */
SELECT  MAX(salary) AS SecondHighestSalary
FROM Employee
WHERE salary < (
SELECT  MAX(salary)
FROM Employee);
Was this solution helpful?

Related Problems