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

what exactly sql injuction.how to overcome.....

2515

How to replace given values with null using nullif()?

966

Can group by and orderby be used together?

993

List all the types of user-defined functions?

1067

How to create a dml trigger using create trigger statements?

1007

how would you troubleshoot blocking? : Sql server database administration

967

What is the exact numeric data type in sql?

986

What is a database in ms sql server?

1035

How would we use distinct statement? What is its use?

1053

What will be the maximum number of indexes per table?

937

What are commonly used odbc functions in php?

998

What is an etl file?

939

Thanks to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?

926

What is a table called, if it has neither cluster nor non-cluster index? What is it used for?

1013

How to execute a sql statement using odbc_exec()?

1117