Very Computer

1. Rownum equivalent

Is there an SQL-Server equivalent to rownum in Oracle.

I'd like to do a query that returns the a sequential number beginning at 1,
which corresponds to the row returned.  I don't want to store the 'rownum'
field in my table.

So the result of the query would be something like..

Select rownum, state from states
ROWNUM STATE
1                  ALABAMA
2                  ALASKA
3                  ARIZONA
.......

2. MS SQL File Size Supported???

3. Equivalent RowNum function in SQL Server

4. database grows from 174k to 48Meg, why!!

5. ROWNUM equivalent in SQl

6. Upgrade from Ingres 1.2 to Ingres II

7. Oracle RowNum Equivalent

8. Help! How do you add this DBF file to DBGrid. (Another Delphi BUG)

9. SQL Server equivalent to Oracle's RowNum

10. Sql server equivalent of rownum

11. how to make the equivalent of rownum ?

12. DB2 Equivalent of Oracle's ROWNUM

13. rownum equivalent in sql server?