mysql数据排序

表格的创建详见:

https://www.cnblogs.com/dssjustdoit/articles/9433732.html

 

1.根据薪水排序

select ENAME,SAL from emp order by SAL;

 2.在一定条件下排序

select ENAME,SAL from emp where JOB='MANAGER' order by SAL;

 3.手动指定从小到大排序

select ENAME,SAL from emp where JOB='MANAGER' order by SAL asc;

 4.有大到小排序

select ENAME,SAL from emp where JOB='MANAGER' order by SAL desc;

 5.按照job和薪水来排序

select ENAME,SAL,JOB from emp order by JOB , SAL;

 注:先根据JOB来进行排序,然后再根据薪水来排序.