Second Highest Salary

The Nth-highest-value pattern tests your understanding of DISTINCT, LIMIT/OFFSET, and NULL handling — and NULL-safe scalar subqueries appear constantly in reporting and ranking queries.

Enable JavaScript for the full StreamPrep guide.