Oracle2

显示雇员名,雇员工资及所在部门的名字
select ename,sal,dname from emp,dept where emp.deptno=dept.deptno;
select ename,sal,dname,dept.deptno from emp,dept where emp.deptno=dept.deptno;

如何显示部门号为10的部门名、员工名和工资
select ename,sal,dname from emp,dept where emp.deptno=dept.deptno and emp.deptno=10;
/*select ename,sal,dname from emp,dept where emp.deptno=dept.deptno=10;*/

显示各个员工的姓名，工资，及其工资的级别
select ename,sal,grade from emp,salgrade wh ere sal>=losal and sal<=hisal;
select ename,sal,grade from emp,salgrade where sal between losal and hisal;

显示雇员名,雇员工资及所在部门的名字,并按部门排序.
select ename,sal,dname from emp,dept where emp.deptno=dept.deptno order by emp.deptno;

?显示员工的上级领导的姓名
/*select ename,mgr from emp where empno=mgr;*/

显示各员工的姓名和他的上级领导姓名
select worker.ename,boss.ename from emp worker,emp boss where worker.mgr=boss.empno;

显示’FORD’的上级.
select worker.ename,boss.ename from emp worker,emp boss where worker.mgr=boss.empno and worker.ename='FORD';

如何显示与SMITH同一部门的所有员工?
select deptno from emp where ename='SMITH'
select ename from emp where deptno=(select deptno from emp where ename='SMITH');

如何查询和部门10的工作相同的雇员的名字、岗位、工资、部门号
select job from emp where deptno=10;
select ename,job,sal,deptno from emp where job in (select job from emp where deptno=10);

如何显示工资比部门30的所有员工的工资高的员工的姓名、工资和部门号
select max(sal) from emp where deptno=30;
select ename,sal,deptno from emp where sal>(select max(sal) from emp where deptno=30);
select ename,sal,deptno from emp where sal>all(select sal from emp where deptno=30);

如何显示工资比部门30的任意一个员工的工资高的员工的姓名、工资和部门号
select ename,sal,deptno from emp where sal>(select min(sal) from emp where deptno=30);
select ename,sal,deptno from emp where sal>any(select sal from emp where deptno=30);