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