Select Code to Download

...
ORDER BY field1, field2
...
-- implicit OFFSET (MySQL)

LIMIT 10,1

...
FROM table1 a, table2 b
WHERE rownum <= 10
...

SELECT TOP 10 field1, field2, ... ,fieldn
FROM ...