Select nth result from a query

I would recommend

select * from table ORDER BY OrderingColumn ASC LIMIT n,1

This is a quirk of limit where if you give it a range, it only returns that range. It works in MySQL too.

SELECT  *
FROM     YourTable
ORDER BY OrderingColumn ASC 
OFFSET  2 ROWS /*Skip first 2 rows*/
FETCH NEXT 1 ROWS ONLY

Note: You cannot use OFFSET ... FETCH without doing an ORDER BY first

Related