SELECT * FROM table LIMIT 99, 21; #### SELECT * FROM table ORDER BY col LIMIT 99, 21;