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 I start sql server?

923

What is the osql utility?

908

Can you explain various data region available in ssrs with their use?

915

How can you know if the row fetched from cursor is still valid in underlying table?

950

What is the sql profiler?

898

What is sql server profiler trace data file?

1047

Why do you need a sql server?

1027

How to perform key word search in tables?

908

What is the data type of time?

909

What is page-level compression?

902

How to select an exiting database using mssql_select_db()?

907

Can we linked SharePoint to a SQL database?

969

Describe the left outer join & right outer join. : sql server database administration

956

Explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?

1095

What do you mean by data manipulation language?

946