SELECT ROW_NUMBER() OVER(ORDER BY eName ASC) AS Rno, * FROM emp asc

how to get the rowid/rownumbes of a table in sqlserver

Question Posted / vimal

Answer Posted / vimal

SELECT ROW_NUMBER() OVER(ORDER BY eName ASC) AS Rno, *
FROM emp

asc or desc required

Is This Answer Correct ?

7 Yes

3 No

Please Help Members By Posting Answers For Below Questions

How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?

1789

How to assign null values to variables or columns?

713

How to select some specific columns from a table in a query in ms sql server?

721

What are the differences between web role and worker role?

116

What is hierarchy, what are its types and difference between them? : sql server analysis services, ssas

921

Why do we partition data?

791

what is database replicaion? What are the different types of replication you can set up in sql server? : Sql server database administration

724

Is it possible to update the views? If yes, how, if not, why?

708

How does index makes search faster?

765

What are the disadvantages of using the stored procedures?

703

How to filter out duplications in the returning rows in ms sql server?

813

How do you debug a procedure in sql server?

638

What are the differences between user defined functions and stored procedures?

739

Mention the different authentication modes in sql server.

701

How do I start sql server?

698