SELECT col1, col2 FROM table ORDER BY col1 LIMIT 10, 10