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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-07-21 : 09:40:44
|
| Rakesh writes "hi,thankx in advance I facing problem in writting query . i need to select 3rd row from table .or nth row from table.will anyone help me.thankx again" |
|
|
graz
Chief SQLTeam Crack Dealer
4149 Posts |
Posted - 2006-07-21 : 09:40:44
|
| Please see our article "What's after top". |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-07-21 : 11:09:57
|
| 3rd or nth row is meaningless until you order it by a columnSelect min(col) from (select top 3 col from table order by col DESC) TMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
find nth 3rd row in table