Fetch third row from table without condition

Question

Hi......

I have a table in Sql Server. I want to fetch third row from table without condition ? Please tell me anyone with an example and also tell me how to fetch third row from table in MySql and Oracle ?

Thanks.....

Kalyan Basa · 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

Vineet Kumar Saini · Answer

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

Vineet Kumar Saini · Answer

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

Senthilkumar · Answer

SELECT SNOProductIDProductName FROM ( SELECT ROW_NUMBER() OVER(ORDER BY ProductID ASC) AS [SNO]ProductID ProductName FROM Products ) sub WHERE sub.SNO = 3