what is SQL query for given table in storeprocedure ?

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
...

select top 10 salary from dbo.Employee_Master order by salary DESC

Select top 10 * from employee
order by emp_salary desc

select top 10 * from emp order by empsal desc