# Paginating Top-30 Terrestrial Planets by Mass with page size 10 (Continue...)
__*LIMIT clause*__
__*Optimize LIMIT offset operation*__

+ Previous last: `| 113 | &EYcK>f(e0S=KeK3qQ | 83163 |`
+ The next 10 rows in 3rd page:
```
SELECT id, name, mass
  FROM planets
  WHERE category_id = 1
    ~!@AND mass <= 83163@!~
    ~!@AND NOT (mass = 83163 and id >= 113)@!~
  ORDER BY mass DESC, id DESC
  LIMIT 10;
+-----+--------------------+-------+
| id  | name               | mass  |
+-----+--------------------+-------+
|  37 | .Dbaxc?y}o2U6oJQNO | 82861 |
...
| 191 | `GM{f$&YuH{-|uuU3) | 76997 |
+-----+--------------------+-------+
10 rows in set (0.00 sec)
```

------------------------------------------------------------
Repeat what we did on 2nd page for the 3rd page, and for the next pages.

```
tidb> SELECT id, name, mass
    ->   FROM planets
    ->   WHERE category_id = 1
    ->     AND mass <= 83163
    ->     AND NOT (mass = 83163 and id >= 113)
    ->   ORDER BY mass DESC, id DESC
    ->   LIMIT 10;
+-----+--------------------+-------+
| id  | name               | mass  |
+-----+--------------------+-------+
|  37 | .Dbaxc?y}o2U6oJQNO | 82861 |
| 240 | RMZHfwQ3gNc1QK<%;c | 81546 |
| 138 | Ls:r7xlaLI.1ZQp?#( | 81398 |
| 276 | xvQZeP`KSp'yFMA3hp | 81044 |
| 325 | R1TxU0$rT${t_@MB'K | 80053 |
| 366 | W4%lW"P&:1(lFtDC]} | 79181 |
| 219 | 9<#YwJ<fb$<Wmflu(h | 78769 |
| 309 | ldQb9@8xCKiPQpqd8F | 78382 |
| 413 | 7-:"!u_Z#jliEC}F,& | 77287 |
| 191 | `GM{f$&YuH{-|uuU3) | 76997 |
+-----+--------------------+-------+
10 rows in set (0.00 sec)

```