1.语法
select 列名1 别名1,列名2 别名2...
from 表名
where 条件
order by 排序列1 asc|desc,排序列2 asc|desc; -- asc表示升序,desc表示降序,不写默认升序
2.示例
select * from emp order by sal;
select * from emp order by sal desc, hiredate;
select 列名1 别名1,列名2 别名2...
from 表名
where 条件
order by 排序列1 asc|desc,排序列2 asc|desc; -- asc表示升序,desc表示降序,不写默认升序
select * from emp order by sal;
select * from emp order by sal desc, hiredate;