Frage im Vorstellungsgespräch bei Tieto

Design a SQL query for nth max value.

Antworten zu Vorstellungsgespräch

Anonym

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

Anonym

15. Dez. 2019

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