SQL-Server-2005

SQL-Server

nth Highest Salary in SQL Server 2005

Mohd_Ahmad

Rate me:

Please Sign up or sign in to vote.

3.33/5 (3 votes)

16 Feb 2011CPOL 25.3K   3   5

SQL

SELECT salary FROM TN a 
    WHERE n - 1 = (SELECT COUNT(salary) FROM TN b WHERE b.salary > a.salary)

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Written By

Mohd_Ahmad

 India

This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

Comments and Discussions

First Prev Next

Re: Looks like you have not modified your vote yet. There is sti... AspDotNetDev22-Feb-11 14:44 AspDotNetDev 22-Feb-11 14:44  Looks like you have not modified your vote yet. There is still only a single vote of 1. Edit: it was changed to a vote of 4. Re: You're right :) *ashamed* I'll modify my vote. phil.o22-Feb-11 8:17 phil.o 22-Feb-11 8:17  You're right *ashamed* I'll modify my vote. Reason for my vote of 1 There are some issues with your quer... Costica U2-Mar-11 13:55 Costica U 2-Mar-11 13:55  Reason for my vote of 1 There are some issues with your query. See Alternate 2. Reason for my vote of 1 First, the SQL request you give seem... phil.o17-Feb-11 5:46 phil.o 17-Feb-11 5:46  Reason for my vote of 1 First, the SQL request you give seems a little bit obscure. Second, you can reach that goal simply with : SELECT TOP 1 salary FROM TN ORDER BY salary DESC Re: I think you are being a little hard here. The Subject says ... Henry Minute17-Feb-11 14:41 Henry Minute 17-Feb-11 14:41  I think you are being a little hard here. The Subject says 'nth highest salary' not 'the highest'.

Last Visit: 31-Dec-99 18:00     Last Update: 18-Apr-24 4:36 Refresh 1

General    News    Suggestion    Question    Bug    Answer    Joke    Praise    Rant    Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.