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)  Substitute of rownum in T-SQL

Author  Topic  zaki1000 Starting Member 1 Post Posted - 2001-01-24 : 17:01:08 Like in Oracle we use rownum to get the row number for a table. I want to know the substitute of rownum in T-SQL. If there is indirect way to get that, Can you suggest me the best possible way.