Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
collegeguy
Starting Member
4 Posts |
 Posted - 2002-01-16 : 05:25:43
|
declare @nthpos intset @nthpos = 3select empname,sal from employee a where @nthpos = ( select count(distinct(sal)) from employee b where a.sal <= b.sal)This will return the nth position in a table.If you wish to use this using the TOP Predicate, how will you do it?C llege Guy |
|
|
Nazim
A custom title
1408 Posts |
Posted - 2002-01-16 : 07:36:59
|
| Read these Article's by Grazhttp://www.sqlteam.com/item.asp?ItemID=566http://www.sqlteam.com/item.asp?ItemID=233----------------------------------"True love stories don't have endings."Edited by - Nazim on 01/16/2002 08:40:13 |
 |
|
|
|
|
|
Nth Position...