MySQL学习笔记3-排序查询

#三、排序查询
/*
语法：select 查询列表3 from 表1 [where 筛选条件2] order by 排序列表4 [asc|desc]
特点：<1>order by支持单个字段，多个字段、表达式、函数，别名;
      <2>asc代表升序，desc代表降序，不写默认是升序；
      <3>order by子句一般是放在查询语句的最后面，limit子句除外
*/
select * from employees order by salary desc;
select * from employees order by salary ;
select * from employees where department_id >= 90 order by hiredate;
select *, salary*12*(1 + ifnull(commission_pct, 0)) from employees order by salary*12*(1 + ifnull(commission_pct, 0)) desc;
select  length(last_name),last_name, salary from employees order by length(last_name) desc;
select * from employees order by salary asc, employee_id desc;