[PHP]
SQL> select empno, ename, job from emp where deptno = 10;
EMPNO ENAMEJOB
---------- ---------- ---------
7782 CLARKMANAGER
7839 KING PRESIDENT
7934 MILLER CLERK
SQL> select b.empno, decode(a.rn,1,b.ename,b.job) info from
2(select rownum rn from dual connect by rownum <= 2) a, emp b
3where b.deptno = 10;
EMPNO INFO
---------- ----------
7782 CLARK
7782 MANAGER
7839 KING
7839 PRESIDENT
7934 MILLER
7934 CLERK
6 rows selected.
..............
[/PHP]
|