# 对查询结果进行分页

__*分页*__
__*Top-N 分析*__

+ **... ORDER BY ... LIMIT offset, count;**
+ 浏览按名称降序排列的行星,一次展示 3 个
  + **SELECT name, mass FROM universe.planets ORDER BY name DESC LIMIT 0, 3;**
  + **SELECT name, mass FROM universe.planets ORDER BY name DESC LIMIT 3, 3;**
-------------------------------------------------------------
分页查询语句需要带有排序条件,除业务排序条件外还应包含主键或者其他唯一键以保证分页稳定,规避没有业务排序字段或者一个业务排序字段值匹配多条记录导致结果集不稳定。如果你在上一页仔细查看了执行计划,你或许已经找到了 `offset:0, count:7` 关键字。现在你可以尝试一些不同的手段来进一步控制 LIMIT 行为来达到分页的效果：offset。

```
tidb> SELECT name, mass FROM universe.planets ORDER BY name DESC LIMIT 0, 3;
+--------+------+
| name   | mass |
+--------+------+
| Venus  | 4.87 |
| Uranus | 86.8 |
| Saturn |  568 |
+--------+------+
3 rows in set (0.01 sec)

tidb> SELECT name, mass FROM universe.planets ORDER BY name DESC LIMIT 3, 3;
+---------+-------+
| name    | mass  |
+---------+-------+
| Pluto   | 0.013 |
| Neptune |   102 |
| Mercury |  0.33 |
+---------+-------+
3 rows in set (0.00 sec)
tidb> SELECT name, mass FROM universe.planets ORDER BY name DESC LIMIT 6;
+---------+-------+
| name    | mass  |
+---------+-------+
| Venus   |  4.87 |
| Uranus  |  86.8 |
| Saturn  |   568 |
| Pluto   | 0.013 |
| Neptune |   102 |
| Mercury |  0.33 |
+---------+-------+
6 rows in set (0.00 sec)
```