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

E.g. to get the 100th row: