Please support our MS SQL advertiser: Programming Forums
 |
•
•
Join Date: Mar 2007
Posts: 52
Reputation: 
Rep Power: 2
Solved Threads: 0
Junior Poster in Training
Hi I m Having a Problem in retrieving records.
I want to get nth maximum value in a column.
I have tried it using top
select top n ColumnName from tablename where(select top n-1 ColumnName from tablename order by columnName desc)
But i m getting all the n records.
Any idea plz
I want to get nth maximum value in a column.
I have tried it using top
select top n ColumnName from tablename where(select top n-1 ColumnName from tablename order by columnName desc)
But i m getting all the n records.
Any idea plz
•
•
Join Date: Apr 2006
Location: East Amherst, NY
Posts: 102
Reputation:
Rep Power: 3
Solved Threads: 6
Junior Poster
I have a feeling you're going to have to use a cursor to get that kind of result. Read up on them, it should be pretty easy, but keep in mind they are a bit slow if you're using a lot of data.
|
Other Threads in the MS SQL Forum
- Previous Thread: selecing rows and their counts in the same query?
- Next Thread: Export tables to XLS
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
