Pergunta de entrevista da empresa Atlassian
Query the Nth highest salary without using row_number() or rank().
Resposta da entrevista
Sigiloso
4 de jun. de 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()