This gets asked alot, so for posterity… Just use LIMIT

E.g. to get the 100th row:

SELECT whatever FROM table LIMIT 100, 1