LeetCode 176: Second Highest Salary

Database

Problem Description

Explanation

To find the second highest distinct salary from the Employee table, we can use a SQL query that selects the maximum salary that is smaller than the maximum salary in the table. We can achieve this by ordering the salaries in descending order and then skipping the first row.

SQL Query

Solutions

# Not applicable for SQL problem

Loading editor...