Write a SQL query to find the 10th highest employee salary from an Emp table.Note: u may assume that there are at least 10 records in the Emp table?

Question

nithin koshy · Answer

SELECT * FROM(SELECT ROWNUMBER()OVER(ORDER BY SALARY DESC)RN,SAL FROM EMP )

WHERE RN=10;

Muhammad Rehan Farooq Usmani · Answer

select top 10 a.salary

from (

select distinct top salary from emp order by salary desc

)a

order by a.salary

chiranjeevi marada · Answer

SELECT TOP1 salary

FROM (

SELECT DISTINCT TOP salary

FROM EMP

ORDER BY salary DESC) a

ORDER BY salary

المصطفى عبد السلام آدم نور الدين · Answer

This query will do that:
Select Top 10 * From Emp