SQL之查询结果排序

1. select ename, job, sal from emp order by sal asc;//desc
2. select ename, job, sal from emp order by sal, comm;
3. select ename from emp order by substr(ename, length(ename)-2);//后三个字母
4. select concat(ename,' ',deptno) as msg from emp order by substr(msg, length(msg)-1);
5. 
   
6. select ename, sal, comm from 
7. (select ename,sal,comm,
8. case when comm is null then 0 else 1 end as is_null 
9. from emp) x 
10. order by is_null desc, comm; //MySQL及其他版本
11. 
    
12. select ename, sal, comm from emp order by comm nulls last; //Oracle版本
13. 
    
14. select ename, sal, job, comm from emp order by
15. case when job='salesman' then comm else sal end;