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

7 Answers
19755 Views
IBM, I also Faced
E-Mail Answers

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to provide values to user defined function parameters?

1064

What is query and its types?

958

What is molap and its advantage? : sql server analysis services, ssas

1036

What is the New in SQL server 2008?

1017

What it means to be triggered?

1082

you accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover? : Sql server administration

1305

How to create a trigger for insert only?

1087

Explain the commands in sql server?

1098

What is cached report?

150

What is onf in normalization form?

1111

Explain differences between web edition and business edition?

119

Write the syntax for stuff function in an sql server?

1074

Explain what are the database objects? : SQL Server Architecture

1145

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

1063

How to get a list of columns using the "sp_help" stored procedure in ms sql server?

1076