Click here to Skip to main content
15,898,134 members

Article Recommendation

Your Name:*
Your Email:*
Your friend's Email:*
The Message text:

Hi!,

This email was created by [MemberName] <[MemberEmail]> who thought you would be interested in the following Article:

"nth Highest Salary in SQL Server 2005"
SELECT TOP 1 salaryFROM (SELECT DISTINCT TOP n salaryFROM employeeORDER BY salary DESC) aORDER BY salarywhere n > 1SQL SERVER – Find Nth Highest Salary of Employee – Query to Retrieve the Nth Maximum value[^]

CodeProject also contains hundreds of articles, free source code samples and applications to help in your day to day programming. Why not give it a try!

 
Note: the details entered on this page will not be stored or used for any purpose other than for sending this email.