oracle查询总结二 逻辑操作符or+排序desc

查询总结二逻辑操作符or+排序desc

#使用逻辑操作符号

工资大于500或者岗位为manager,同时还要满足姓名首字符为大写J

select * from emp where( sal>500 or job=’manager’) and ename like ‘J%’;

#工资从低到高，升序

select * from emp order by sal;

#工资从高到低，降序

select * from emp order by sal desc;

#部门号升序而雇员的工资降序排列

select sal,ename,deptno from emp order by deptno, sal desc

#入职时间降序

select sal,ename,deptno,hiredate from emp order by deptno, hiredate desc

#使用列的别名排序

select ename,(sal+nvl(comm,0)*12) “年薪” from emp order by “年薪”