Find Salary Particular Number

Posted by Jayakumars under Sql Server category on 4/23/2013 | Points: 40 | Views : 3499

Post Code |

Search Codes |

Code Home

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

Alert Moderator

Bookmark It

Comments or Responses

Latest Code Snipptes

writing Custom pagination html code in python and django
Code snippet for setInterval
Azure Function - Connect to MS Dynamics using application user - .NET core 3.1
MS Dynamics 365- Custom action - Read input parameter values from plugin
MS Dynamics 365- Disassociate record from N-N relationship entity
Search box with icon in Navbar in bootstrap 4
Remove HTML tags using Regular Expression in C#
MS Dynamics 365- Close Quote from C# / Custom action
How to show and hide submenu in tabs using jquery
More ...