Domanda di colloquio di Tieto
Design a SQL query for nth max value.
Risposte di colloquio
Anonimo
19 ott 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.
Anonimo
Something like SELECT TOP 6 salary FROM ( SELECT DISTINCT TOP 6 salary FROM employee ORDER BY salary DESC) a ORDER BY salary