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

What type of locking occurs during the snapshot generation? : sql server replication

1377

What is the command used to check locks in microsoft sql server?

1102

Explain the dbcc pintable command when would you use it?

970

How many types of triggers in sql server?

1093

How you can change a cross join into an inner join?

1022

What is merge statement?

1135

Can we call future method from trigger?

1005

How to turn off warning messages during php execution?

1109

What is the maximum size of column in sql server?

946

How to create indexed view?

1108

Can we add our custom code in ssis?

1040

When I delete any data from a table, does the sql server reduce the size of that table?

1064

Which is the latest version of sql server and when it is released?

1201

What is an index in sql?

1069

What is a rownum?

1063