427-2.sql

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

select  empno,ename,job,sal  from  scott.emp  where sal<=2000 group by job,empno,ename,sal