use this...
select * from
(
select emp_id,emp_name,emp_salary, Rank() over (order by emp_Salary desc) as Sal_Rank
from employee
)
as temp where Sal_Rank<=10
Order by Sal_Rank, Emp_Id
this will give employees list having top 10 highest salaries.
e.g...
empid name sal sal_rank
----------------------------------
1 samarth 100000 1
2 aadarsh 100000 1
5 tarak 90000 2
...
Happy Coding!
:)