select ename, sal, (select min(sal) from emp e3 where e3.sal > e1.sal and e3.ename in ('JAMES', 'CLARK', 'WARD')) 小于的工资 from emp e1 where e1.sal < any (select e2.sal from emp e2 where e2.ename in ('JAMES', 'CLARK', 'WARD')) ENAME SAL 小于的工资 ---------- --------- ---------- SMITH1 800.00 950 JAMES 950.00 1250 ADAMS 1100.00 1250 WARD 1250.00 2450 MARTIN 1250.00 2450 MILLER 1300.00 2450 TURNER 1500.00 2450 ALLEN 1600.00 2450
sal,
(select min(sal)
from emp e3
where e3.sal > e1.sal
and e3.ename in ('JAMES', 'CLARK', 'WARD')) 小于的工资
from emp e1
where e1.sal < any (select e2.sal
from emp e2
where e2.ename in ('JAMES', 'CLARK', 'WARD'))
ENAME SAL 小于的工资
---------- --------- ----------
SMITH1 800.00 950
JAMES 950.00 1250
ADAMS 1100.00 1250
WARD 1250.00 2450
MARTIN 1250.00 2450
MILLER 1300.00 2450
TURNER 1500.00 2450
ALLEN 1600.00 2450
8 rows selected