基本要点
格式:
order by {column_name1, column_name2, column_name3, …column_namen} [asc|desc]
说明:
{column_name1, column_name2, column_name3, …column_namen}:指定需要排列的字段
[asc|desc]:指定排列策略,asc以升序排列,desc以降序排列,默认以升序排列。
顺序规定:
数字类型:小值在前面显示;
日期类型:早的日期在前面显示;
字符类型:依据字母顺序显示,a在前,z最后
示例
select * from student order by age;#age升序排列
select * from student order by age asc;#age升序排列
select * from student order by age desc;#age降序排列
多重排序时:在前一个限定相同的基础上后面的才排序:
select * from student order by age,mobile desc;
其中age是默认的升序排序,当age相同时,mobile才降序排序。