重庆网站快速排名提升,成功的网络营销案例有哪些,PHP与网站建设的课后笔记,汕头食品骏域网站建设025排序操作
select .. from .. order by 字段 asc/descselect empno, ename, sal from emp order by sal asc;asc 不写的话#xff0c;默认升序
多个字段排序
查询员工的编号、姓名、薪资#xff0c;按照薪资升序排列#xff0c;如果薪资相同的#xff0c;再按照姓名升…025排序操作
select .. from .. order by 字段 asc/descselect empno, ename, sal from emp order by sal asc;asc 不写的话默认升序
多个字段排序
查询员工的编号、姓名、薪资按照薪资升序排列如果薪资相同的再按照姓名升序排列。
select empno,ename,sal from emp order by sal asc, ename asc;
select empno,ename,sal from emp order by 3 asc, 2 asc;select ename,job,sal from emp where job in (MANAGER,SALESMAN) order by sal desc;select ename,job,sal*12 as yearsal from emp where job in (MANAGER,SALESMAN) order by yearsal asc;说明order在select后执行优先级低
select ename,job,sal*12 as yearsal from emp where job in (MANAGER,SALESMAN) order by sal asc;按原始名字sal排序也可
