how to get the rowid/rownumbes of a table in sqlserver
Answers were Sorted based on User's Feedback
Answer / payal nath
SELECT ROW_NUMBER() OVER(ORDER BY <FieldName>)
FROM <TableName>
Is This Answer Correct ? | 27 Yes | 5 No |
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 |
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 |
Answer / dhivakar
SELECT
ROW_NUMBER() OVER (ORDER BY emp_id) AS rowid,
*
FROM employee
Is This Answer Correct ? | 0 Yes | 0 No |
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 |
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 |
Will sql server 2005 allow you to reduce the size of a column?
What is difference between join and natural join?
What is BCP? When does it used in sql server 2012?
0 Answers TryTechnicals Pvt Ltd,
What do you mean by an execution plan?
can you instantiate a com object by using t-sql? : Sql server database administration
How get current date in SQL server 2000
4 Answers Cap Gemini, Polaris,
What is difference between equi join and inner join?
What is the difference between index seek vs. Index scan?
What is the Control Flow in SSIS
What is Full Outer Join?
What xml support does the sql server extend?
What is sql server profiler?