对查询结果进行排序:
SELECT * FROM table_name ORDER BY 列;(数字按大小排列,字符或字符串按字母排序,默认正序排列)
或:
SELECT * FROM table_name ORDER BY 列 DESC; (倒序排列)
对查询结果进行排序:
SELECT * FROM table_name ORDER BY 列;(数字按大小排列,字符或字符串按字母排序,默认正序排列)
或:
SELECT * FROM table_name ORDER BY 列 DESC; (倒序排列)