Write a query to find the Nth highest salary (for example the 3rd).

Answer preview

Generalise the same DENSE_RANK() pattern by filtering on rnk = N — shown here with N = 3 for the third highest salary.…