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 - 2005-03-01 : 07:46:11
|
| Robin writes "How can i display rownumber in a column. Like if there are three fields in a table i.e. first, last and city. If there are 50 records in the table , i want to display each rows record number along with the three fields. Such as rownum , first , last , cityRownum first last city01 Mike Johnson NY02 dddd dddd sdsd0304...50 The rownum is not a field in the table, it should be created only at the time of viewing data" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-03-01 : 07:46:40
|
| Try these:http://www.sqlteam.com/searchresults.asp?SearchTerms=row+number |
 |
|
|
|
|
|
SQL 2000 , ROW NUM