ORDER BY
子句对查询结果进行排序。你可以根据一个或多个列的值按升序(ASC)或降序(DESC)进行排序。,,``sql,SELECT * FROM your_table_name ORDER BY column_name ASC;,
`,,或者按降序排序:,,
`sql,SELECT * FROM your_table_name ORDER BY column_name DESC;,
`,,你也可以根据多个列进行排序:,,
`sql,SELECT * FROM your_table_name ORDER BY column1 ASC, column2 DESC;,
``