Grokking SQL for Tech Interviews
Ask Author
Back to course home

0% completed

Vote For New Content
3. 2nd Highest Salary
On this page

Problem

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.

Problem Definition

Write a solution to find the 2<sup>nd</sup> highest salary from the Employee table. If there is no 2<sup>nd</sup> highest salary, return null.

Example

Here's the employee table:

Expected Output

Try It Yourself

.....

.....

.....

Like the course? Get enrolled and start learning!

On this page