多行子查询中all和any的使用
all的练习
SELECT ename,job,deptno
FROM emp
WHERE sal > (SELECT MAX(sal) FROM emp WHERE deptno = 30)
SELECT ename,job,deptno
FROM emp
WHERE sal >ALL(SELECT sal FROM emp WHERE deptno = 30)
any的练习
SELECT ename,job,deptno
FROM emp
WHERE sal > (SELECT MIN(sal) FROM emp WHERE deptno = 30)
SELECT ename,job,deptno
FROM emp
WHERE sal >ANY(SELECT sal FROM emp WHERE deptno = 30)