limit
select ... limit start,rows;
``
- start 开始位置 (start+1位置开始)
- rows 记录数量
## 分页公示
```mysql
select * from tableName
group by XXX
limit 显示记录数*(第几页-1),每页个数;
example
select *
from emp
order by empno
limit 0,3;
# 第三页
select *
from emp
order by empno desc
limit 10,5;
# 第五页
select *
from emp
order by empno desc
limit 20,5;