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