Pergunta de entrevista da empresa LTIMindtree
how do you find salary nth in SQL?
Resposta da entrevista
Sigiloso
13 de nov. de 2023
SELECT salary FROM ( SELECT salary, DENSE_RANK() OVER (ORDER BY salary DESC) AS rank FROM employees ) AS ranked_salaries WHERE rank = N;