Tieto interview question
Design a SQL query for nth max value.
Interview Answers
Anonymous
19 Oct 2019
Something like SELECT TOP 6 salary FROM ( SELECT DISTINCT TOP 6 salary FROM employee ORDER BY salary DESC) a ORDER BY salary
1
Design a SQL query for nth max value.
Anonymous
Something like SELECT TOP 6 salary FROM ( SELECT DISTINCT TOP 6 salary FROM employee ORDER BY salary DESC) a ORDER BY salary
Check out your Company Bowl for anonymous work chats.