数据抽出选项
===
## 知识点
- order by
- limit
- offset
## 实战
```
> select * from users order by score asc;
> select * from users order by score desc;
> select * from users order by team;
> select * from users order by team,score;
> select * from users order by team desc,score desc;
> select * from users order by score desc limit 3 offset 1;
```
## 分页算法:
```
sql:`select * from tab_name limit 3 offset (1-1)*3`偏移数:计算 (page - 1) \* limit
```
