Sollicitatievraag bij Tieto
Design a SQL query for nth max value.
Antwoorden op sollicitatievragen
Anoniem
19 okt 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.
Anoniem
Something like SELECT TOP 6 salary FROM ( SELECT DISTINCT TOP 6 salary FROM employee ORDER BY salary DESC) a ORDER BY salary