How do you find out the 8th highest salary in an employee table? (SQL Question)

Question

Sigiloso · Accepted Answer

SELECT TOP 1 salary
FROM (
      SELECT DISTINCT TOP n salary
      FROM employee
      ORDER BY salary DESC
      ) a
ORDER BY salary

(n = desired number)

FIS

Pergunta de entrevista da empresa FIS

Resposta da entrevista

Empresas seguidas

Buscas de vagas