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

Categories >> Software >> Databases >> SQL Server
Suggest New Category

Question Posted / y babu

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

Answers were Sorted based on User's Feedback

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

Answer / payal nath

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

Is This Answer Correct ?

27 Yes

5 No

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

Answer / renu

Row_number() works on SQL 2005 and upper version, if u r
trying it on 2000 it will not work.

Is This Answer Correct ?

8 Yes

2 No

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

Answer / vimal

SELECT ROW_NUMBER() OVER(ORDER BY eName ASC) AS Rno, *
FROM emp

asc or desc required

Is This Answer Correct ?

7 Yes

3 No

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

Answer / vivek

Select Count(*) as ro_no from <tablename>

Is This Answer Correct ?

6 Yes

6 No

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

Answer / dhivakar

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

Is This Answer Correct ?

0 Yes

0 No

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

Answer / samar

hi i had tried same but i am getting error

Server: Msg 195, Level 15, State 10, Line 1
'row_number' is not a recognized function name

here querry is

select row_number() over(order by Income_Verification_id
) from Dim_Income_Verification

plz reply !!

Is This Answer Correct ?

5 Yes

7 No

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

Answer / raman

If you want row id as ROWID in Oracle, use %%physloc%% to
get unique id for each row in a table.
Ex. Query to get physical address/rowid of first row in
table.
SELECT TOP 1 %%physloc%% AS ROWID FROM <UrTable>

Is This Answer Correct ?

1 Yes

3 No

Post New Answer