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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Row No with Select Query

Author  Topic 

rizwan
Starting Member

9 Posts

Posted - 2002-05-16 : 08:55:58
Dear Reader
Can i get row no with any recordset generated through select Query
e.g.
I have a table/View "Users" with data
User|XXX
----|----
ali | hjgf j
asif|df gjkhdfkjh

now if i use select query e.g.

select * from Users

i get records
User|XXX
----|----
ali | hjgf j
asif|df gjkhdfkjh

can i get
SNO | User|XXX
----|-----|----
1 |ali | hjgf j
2 |asif | df gjkhdfkjh

My email
rizwan_1574@hotmail.com

Nothing

robvolk
Most Valuable Yak

15732 Posts

Posted - 2002-05-16 : 08:59:09
A little search on SQL Team would've saved you the trouble of posting:

http://www.sqlteam.com/SearchResults.asp?SearchTerms=row+number

Go to Top of Page
   

- Advertisement -