SELECT ROW_NUMBER() OVER (ORDER BY emp

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

Question Posted / dhivakar

7 Answers
19609 Views
IBM, I also Faced
E-Mail Answers

Answer Posted / dhivakar

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

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Can you leave a union at any time?

1069

What are xml indexes?

957

What is field in algebra?

1047

What is nonclustered index on computed columns?

966

What is checkpoint in sql server?

1176

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

1092

What is a derived table?

935

Why do we use sql limitations? Which constraints can we use while making a database in sql?

1085

What does nvl stand for?

950

What is a self join in sql server?

1144

Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?

1060

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

1514

can we have a nested transaction? : Sql server database administration

1107

Explain sql delete command?

1063

What are the database roles? : sql server security

1200