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!