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>

Explain what is raid and what are different types of raid levels?

0 Answers  

Difference Between ORDER BY Clause and GROUP BY Clause in SQL?

0 Answers   MCN Solutions,

can we have a nested transaction? : Sql server database administration

0 Answers  

How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?

0 Answers  

Write the SQL query to drop, truncate and delete table.

0 Answers   HPCL, Hughes Systique Corporation, Ittiam Systems,

How can we write or define DDL statements in Sql server and DML statements?

3 Answers  

Explain different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

0 Answers  

Explain aggregate functions?

0 Answers  

Explain about system stored procedure?

0 Answers  

What are the different subsets of sql?

0 Answers  

You are designing a database for your human resources department in the employee table, there is a field for social security number, which cannot contain null values if no value is given, you want a value of unknown to be inserted in this field what is the best approach?

0 Answers  

What is the sql case statement used for? Explain with an example?

0 Answers