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 to check if stored procedure is running in sql server?

1069

What do you mean by stored techniques? How would we use it?

1043

How do you migrate data from mssql server to azure?

165

What are the differences between char and varchar in ms sql server?

1074

What is self contained multi valued query?

1025

What is the difference between executequery () and executeupdate ()?

1050

Explain the different types of joins?

1001

What is database black box testing?

1037

Tell me what is difference between view and materialized view?

947

What is dml command?

978

Is it possible for a stored procedure to call itself or recursive stored procedure?

955

What is executereader?

963

Which are the two editions in which SQL Azure database available?

119

can you implement data mining in SSRS?

151

Write query to return all rows sql?

1066