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 |
|
tt8080
Starting Member
1 Post |
 Posted - 2002-09-21 : 23:21:35
|
| SELECT name from authors -- all rowsSELECT top 1 name from authors -- the first rowBut how to select every row with row_number=i(i=1..count(*))?Please help me...! |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-09-22 : 08:24:16
|
| ?????You'll have to supply some sample data and the output you wish to get. Right now your question makes no sense at all (every row with the SAME row number???) |
 |
|
|
nizmaylo
Constraint Violating Yak Guru
258 Posts |
Posted - 2002-09-27 : 14:08:37
|
| He means grouped top results.The answer is: Ken Henderson / The Guru's Guide To Transact SQL, Chapter 6, page 125.helena |
|
|
|
|
|
|
How to select every row 'only'?