Pregunta de entrevista de Tieto
Design a SQL query for nth max value.
Respuestas de entrevistas
Anónimo
19 de oct de 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.
Anónimo
Something like SELECT TOP 6 salary FROM ( SELECT DISTINCT TOP 6 salary FROM employee ORDER BY salary DESC) a ORDER BY salary