442.sql

来自「Oracle 9i中文版基础培训教程」· SQL 代码 · 共 4 行

select  emp.empno,emp.ename,emp.job,emp.sal  
from scott.emp
where sal in (select sal from scott.emp where ename='WARD');