SELECT ROW_NUMBER() OVER (ORDER BY emp

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

Question Posted / dhivakar

Answer Posted / dhivakar

SELECT
ROW_NUMBER() OVER (ORDER BY emp_id) AS rowid,
*
FROM employee

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Why transaction is important?

944

What is used to replicate sessions between instances in coldfusion clusters?

1030

Do you know the policy based administration feature of sql server 2008?

924

What the different types of Replication and why are they used?

1007

Is the primary key column of a table an index in ms sql server?

933

Is candidate a key?

909

Which table keeps the locking information?

893

How many levels of sp nesting are possible?

976

explain what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration

872

Is null vs coalesce?

835

Explain indexed views and partitioned view with their syntax.

1105

What are the different SQL Server Versions you have worked on?

971

What is function of CUBE ?

994

What is the use of RDBMS?

969

What is tempdb database? : SQL Server Architecture

1140