LTM Limited interview question
how do you find salary nth in SQL?
Interview Answer
Anonymous
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;
how do you find salary nth in SQL?
Anonymous
SELECT salary FROM ( SELECT salary, DENSE_RANK() OVER (ORDER BY salary DESC) AS rank FROM employees ) AS ranked_salaries WHERE rank = N;
Check out your Company Bowl for anonymous work chats.