How to fetch Nth row in MySQL? [duplicate]

SELECT * 
FROM YourTable 
ORDER BY <somefield>
LIMIT N-1, 1

http://www.w3schools.com/php/php_mysql_select_limit.asp

The SQL query below says "return only 10 records, start on record 16 (OFFSET 15)":
$sql = "SELECT * FROM Orders LIMIT 10 OFFSET 15";

You could also use a shorter syntax to achieve the same result:
$sql = "SELECT * FROM Orders LIMIT 15, 10";