How to solve: Calculate Second Highest Salary?

Question

Accepted Answer

To get the second highest salary:
1. Select distinct salaries descending: `SELECT DISTINCT salary FROM Employee ORDER BY salary DESC`.
2. Use `LIMIT 1 OFFSET 1` to skip the top salary and retrieve the second.
3. Wrapping inside an outer scalar select guarantees `NULL` return if fewer than 2 distinct salaries exist.