46.
(多选题)列出EMP表中,比20号部门所有员工工资高的员工姓名,工资,部门号
下列正确的SQL语句是( )。
A.SELECT ename,sal,deptno FROM emp
WHERE sal>ANY(SELECT sal FROM emp WHERE deptno=20);
B.SELECT ename,sal,deptno FROM emp
WHERE sal>ALL(SELECT sal FROM emp WHERE deptno=20);
C.SELECT ename,sal,deptno FROM emp
WHERE sal>(SELECT MAX(sal) FROM emp WHERE deptno=20);
D.SELECT ename,sal,deptno FROM emp
WHERE sal>(SELECT MIN(sal) FROM emp WHERE deptno=20);