The second-highest salary: Why the simplest SQL query is often the smartest

Spoiler: That elegant two-line MAX() subquery? It’s not just clever—it’s correct, portable, and often...