Atlassian Interview Question
Query the Nth highest salary without using row_number() or rank().
Interview Answer
Anonymous
Jun 4, 2026
It was is MS SQL which at the time didn't know LIMIT was not a keyword in it. They ended up asking if I could do it using a window function where I just used DENSE_RANK()