About sub Quries

[praveenmandadi]

Hi

Need help in sql sever2000

plz help to write query for the retriving the field values of nth row in a table or joining two tables

[jagadishbabub]

Hi Praveen,

Try this .......

SELECT * FROM
(SELECT ROW_NUMBER() OVER(ORDER BY EMPNo) ROW_No, EMPNO, EMPNAME
FROM EMP_DUPLICATE) AS Emp_Duplicate_WithRowNumbers
WHERE ROW_No = n (n stands for the Row number which you want to retrieve)

Regards,
Jagadish Babu