1.单字段排序
mysql> select ename,esal from emploee order by esal;
默认为升序排序
指定降序(后面加desc),指定升序(后面加asc)
mysql> select ename,esal from emploee order by esal desc;
mysql> select ename,esal from emploee order by esal asc;
2.多字段排序
例如:查询员工的名字和工资,按照工资升序排序,如果工资一样,再按照名字排序;
mysql> select ename,esal from emploee order by esal asc,ename asc;
注意:只有当工资相同时,后面的名字排序才会生效
3.综合一点的案例:
找出工资在1200到4000之间的员工信息,要求按照薪资降序排列.
mysql>select * from emploee where esal between 1200 and 4000 order by esal desc;