SQL query to find nth max salary

• Use ORDER BY and LIMIT to get the nth max salary

• Use subquery to avoid duplicates in case of ties

• Example: SELECT salary FROM employees ORDER BY salary DESC LIMIT n-1, 1