LeetCode 176: Second Highest Salary
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
Related LeetCode Problems
Loading editor...