Fetch third row from table without condition

Accepted answer

Hi Vineet,

SELECT TOP 1 * FROM (
SELECT TOP 3 * FROM CONTACTS
ORDER BY EMP_ID ASC
) A ORDER BY A.EMP_ID DESC

Hope this helps.

Thanks,
Kalyan Basa

Thanks Kalyan...........

Hi Senith I asked fetch third row from a table without condition ?

SELECT SNO,ProductID,ProductName FROM

(

SELECT ROW_NUMBER() OVER(ORDER BY ProductID ASC) AS [SNO],ProductID, ProductName

FROM Products

) sub

WHERE sub.SNO = 3