SELECT ROW_NUMBER() OVER(ORDER BY <FieldName>) FROM <TableName>

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

Question Posted / payal nath

Answer Posted / payal nath

SELECT ROW_NUMBER() OVER(ORDER BY <FieldName>)
FROM <TableName>

Is This Answer Correct ?

27 Yes

5 No

Please Help Members By Posting Answers For Below Questions

How retrieve field names from the table in SQL through JAVA code?

1958

What is best institute to Learn DotNET And SQL in chennai?

2219

Why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it?

943

How to use values from other tables in update statements in ms sql server?

1185

What are the types of joins in sql?

1171

What is key set driven?

1009

Explain what are magic tables in sql server?

1046

what is a self join? : Sql server database administration

1122

Explain the advantages of merge replication?

1011

Explain syntax for viewing, dropping and disabling triggers?

997

Explain what are commit and rollback in sql?

982

How to set database to be single_user in ms sql server?

1082

What are the drawbacks of reporting in ssrs?

159

What is outer join in sql server joins?

1186

How many types of objects are there?

1071