语法:SELECT 列名 FROM 表名 ORDER BY 列名 ASC | DESC;
mysql> SELECT * FROM student_info; +------+---------+ | age | name | +------+---------+ | 12 | Lili | | 27 | Jack | | 25 | Rose | | 25 | Ann | | 26 | Mark | | 68 | Bill | | 16 | James | | 20 | Fred | | 8 | Gary | | 22 | Martin | | 35 | Charles | | 31 | Joseph | | 49 | Henry | | 57 | Mike | | NULL | Bob | +------+---------+ 15 rows in set (0.01 sec) mysql>
(1)用ACS表示按正序排序(即:从小到大排序)
mysql> SELECT * FROM student_info ORDER BY age ASC; +------+---------+ | age | name | +------+---------+ | NULL | Bob | | 8 | Gary | | 12 | Lili | | 16 | James | | 20 | Fred | | 22 | Martin | | 25 | Rose | | 25 | Ann | | 26 | Mark | | 27 | Jack | | 31 | Joseph | | 35 | Charles | | 49 | Henry | | 57 | Mike | | 68 | Bill | +------+---------+ 15 rows in set (0.00 sec) mysql>
(2)用DESC表示按倒序排序(即:从大到小排序)
mysql> SELECT * FROM student_info ORDER BY age DESC; +------+---------+ | age | name | +------+---------+ | 68 | Bill | | 57 | Mike | | 49 | Henry | | 35 | Charles | | 31 | Joseph | | 27 | Jack | | 26 | Mark | | 25 | Ann | | 25 | Rose | | 22 | Martin | | 20 | Fred | | 16 | James | | 12 | Lili | | 8 | Gary | | NULL | Bob | +------+---------+ 15 rows in set (0.00 sec) mysql>