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>

Why should you use or avoid select * statements?

0 Answers  

explain different levels of normalization? : Sql server database administration

0 Answers  

Where are stored procedures in sql server?

0 Answers  

What is measure group, measure? : sql server analysis services, ssas

0 Answers  

Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables?

2 Answers  

Define left outer join?

0 Answers  

what's the difference between delete table and truncate table commands? : Sql server database administration

0 Answers  

What is sql service broker?

0 Answers  

What is store procedure? How do they work?

0 Answers  

How many databases instances are there in sql server 2000?

0 Answers  

Can a table be created inside a trigger?

0 Answers  

In what three ways is the return statement used in a stored procedure?

0 Answers