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

Question

Anonymous · 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

FIS Interview Question

Interview Answer

Want the inside scoop on your own company?

Bowls

Followed companies

Job searches