441.sql

Oracle 9i中文版基础培训教程

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