Write a SQL query that will produce the 10Th largest salary from an Employees table.

Question

Philip · Accepted Answer

Glass door wont let me edit but switch 6 to 10 as shown below
SELECT TOP 1 SALARY
FROM ( SELECT DISTINCT TOP 10
ORDER BY SALARY DESC) AS TENTHSALARY
ORDER BY SALARY

Levent Ozdemir · Answer

select top 10 percent topsalaries.salary from (select top 10 Salary from Employee order by Salary desc) as topsalaries order by topsalaries.Salary asc

Philip · Answer

SELECT TOP 1  SALARY
FROM  ( SELECT DISTINCT TOP 6 
ORDER BY  SALARY DESC) AS TENTHSALARY
ORDER BY SALARY

Slalom

Pregunta de entrevista de Slalom

Respuestas de entrevistas

Empresas seguidas

Búsquedas de empleo