Answer / payal nath

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

Answer / renu

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

Answer / vimal

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

asc or desc required

Answer / vivek

Select Count(*) as ro_no from <tablename>

Answer / dhivakar

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

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 !!

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>

Do you have any idea about the tcl commands?

0 Answers  

what is the signification difference of this bit data type between sql 6.5 and later version sql server?

1 Answers  

What is the difference between varchar and nvarchar types?

1 Answers  

What is sparse columns of sql server 2008?

0 Answers  

How to enter comments in transact-sql statements?

0 Answers  

How to create an identity column?

0 Answers  

How to get max 100 values from sql server

7 Answers  

How do you find value of first column before inserting value into the second column in the same table for checking that second column must have different value than first column.

2 Answers   L&T,

Delete duplicate rows from a table without primary key by using a single query Table Employee empname salary A 200 B 300 A 200 C 400 D 500 D 500 Output should be A 200 B 300 C 400 D 500

14 Answers  

How will oyu test the stored procedure taking two parameters namely first name and last name returning full name?

3 Answers  

What is query and its types?

0 Answers  

How to set the current database in ms sql server?

0 Answers