**
排序
**
语法:
select 查询列表 from 表 【where 筛选条件】 order by 排序列表[asc desc] (desc 从高到低)
(asc)从低到高 默认是asc 升序
order by 后面也可以跟表达式 也支持别名
案例:查询员工信息,工资从高到低
select * from employees order by salary desc;
从低到高
```sql
select * from employees order by salary asc;
order by 后面也可以跟别名
如果order by 后面写多个字段
salary 从低到高 工资一样的 employee_id 从高到低
length() 字节长度
eg select length(last_name) as 字节长度,last_name,salary from employees
order by length(last_name) desc;