Find Salary Particular Number

Jayakumars
Posted by Jayakumars under Sql Server category on | Points: 40 | Views : 2878
Hi
I post the code nth Salary

Select * from Tbl_Salary
Exec Sp_SelectNthSalry 5

Create Proc Sp_SelectNthSalry
@Id int
as
Select *,Row_Number() over (order by Salary Desc)as Id from Tbl_Salary where Id=@Id

Comments or Responses

Login to post response