精选优质文档-倾情为你奉上/*1、找出奖金高于工资的员工*/ select * from emp where commsal;/*2、找出每个员工奖金和工资的总和 */ select ename,decode(comm,null,0,comm)+sal from emp/*3、找出部门10中的经理(MANAGER)和部门20中的普通员工(CLERK) */ select * from emp where deptno=10 and job=MANAGER or deptno=20 and job=CLERK;/*4、找出部门10中既不是经理也不是普通员工，而且工资大于等于2000的员工 */ select * from emp where deptno=10 and jobMANAGER and jobCLERK and sal=2000;select * from emp where deptno=10 and job not in (MANAGER ,CLERK )and sa
