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 is compound operators?

1059

Give me a SQL Query to find out the second largest company?

1167

What are different types of join?

1318

What are the dmvs? : sql server database administration

1062

What are the rendering extensions of ssrs?

157

What is clustered primary key?

1028

What are the types of subquery?

1042

Can we call stored procedure in trigger?

950

How to make a remote connection in a database?

977

What is similarity and difference between truncate and delete in sql?

1102

‘Order by’ is not allowed in a view how can you sort information from a view?

1085

How to rebuild indexes with alter index ... Rebuild?

1127

What are the different authentication modes in sql server? How can it be changed?

1090

in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it

1514

What is the server name for sql management studio?

1025