Q1
Medium
How do you find the second highest salary in an employees table?
You can use a subquery or modern SQL window functions (DENSE_RANK).
Solution Code
-- Method 1: Subquery with MAX
SELECT MAX(salary) AS second_highest
FROM employees
WHERE salary < (SELECT MAX(salary) FROM employees);
-- Method 2: Window Function
WITH RankedSalaries AS (
SELECT salary, DENSE_RANK() OVER (ORDER BY salary DESC) as rank
FROM employees
)
SELECT salary FROM RankedSalaries WHERE rank = 2 LIMIT 1;