Question d’entretien chez Tieto

Design a SQL query for nth max value.

Réponses aux questions d'entretien

Utilisateur anonyme

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

Utilisateur anonyme

15 déc. 2019

Select distinct salary from table order by salary desc limit 6;