1.排序查询:
select 查询列表 from 表 【where 筛选条件】order by 排序列表【asc(低到高)|desc(高到低)】
select * from employees order by salary desc;高到低(降序)
select * from employees order by salary asc;低到高(升序)
不写默认是升序;