显示雇员名,雇员工资及所在部门的名字

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);