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 |
What is a Linked Server?
Sql studio em braces a variety of capabilities, but will I need them all? Is there a simpler product ? : sql server management studio
What is the significance of null value and why should we avoid permitting null values?
How to use linked server?
What is trigger and different types of Triggers?
What is difference between joins and subqueries?
Explain rdbms?
What is an extended stored procedure? Can you instantiate a COM object by using T-SQL?
What is a partition function in sql server?
How many types of cursor type are there?
What is b tree index?
query processing