> For the complete documentation index, see [llms.txt](https://jen-hsuan-hsieh.gitbook.io/database/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://jen-hsuan-hsieh.gitbook.io/database/chapter1/12mysql-for-beginners/122beginning-with-mysql-basics/1229sorting-the-data-using-order-by.md).

# 1.2.2.9.Sorting the Data Using ORDER BY

* 查詢並排序
  * 降冪 (DESC)
  * 升冪 (ASC) 
  * 數字
  * 子母順序

    ![](https://1088158622-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M4M0G87SQJ28mvsXOhL%2F-M4M0IBPb1goOGpuG1BI%2F-M4M0Q1kENahzPIKKq0E%2F2018041411.jpg?generation=1586302932728019\&alt=media)