Oracle_SQL练习_04

--1、列出至少有一个雇员的所有部门
/*SELECT DISTINCT t1.deptno, t2.dname
FROM   emp t1, dept t2
WHERE  t1.deptno = t2.deptno
ORDER  BY t1.deptno*/
--2、列出薪金比"SMITH"多的所有雇员
/*SELECT empno, ename, nvl(sal, 0) AS salary
FROM   emp
WHERE  nvl(sal, 0) > (SELECT nvl(sal, 0) FROM emp WHERE ename = 'SMITH')
*/
--3、列出所有雇员的姓名及其直接上级的姓名
/*SELECT t1.ename, t2.ename
FROM   (SELECT ename, mgr FROM emp) t1, (SELECT ename, empno FROM emp) t2
WHERE  t1.mgr = t2.empno*/
--4、列出入职日期早于其直接上级的所有雇员
/*SELECT t1.ename, t1.hiredate, t2.ename, t2.hiredate
FROM   (SELECT ename, mgr, hiredate FROM emp) t1,
       (SELECT ename, empno, hiredate FROM emp) t2
WHERE  t1.mgr = t2.empno
       AND t1.hiredate < t2.hiredate*/
--5、列出部门名称和这些部门的雇员,同时列出那些没有雇员的部门
/*SELECT de