Tieto Interview Question
Design a SQL query for nth max value.
Interview Answers
Anonymous
Oct 19, 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.