數據抽出選項
===
## 知識點
- 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
```