Pregunta de entrevista de LTIMindtree
how do you find salary nth in SQL?
Respuesta de la entrevista
Anónimo
13 nov 2023
SELECT salary FROM ( SELECT salary, DENSE_RANK() OVER (ORDER BY salary DESC) AS rank FROM employees ) AS ranked_salaries WHERE rank = N;