> For the complete documentation index, see [llms.txt](https://huataihuang.gitbook.io/cloud-atlas-draft/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://huataihuang.gitbook.io/cloud-atlas-draft/database/mysql/sql/sort_results.md).

# 查询结果排序

* 语法

```sql
SELECT field1, field2,...fieldN table_name1, table_name2...
ORDER BY field1, [field2...] [ASC [DESC]]
```

> * 只要field被列出，就可以排序
> * 可以根据多个字段排序
> * `ASC`是顺序，`DESC`是逆序
> * 可以结合`WHERE...LIKE`条件

## 参考

* [MySQL - Sorting Results](https://www.tutorialspoint.com/mysql/mysql-sorting-results.htm)