WITH temp AS (SELECT * FROM emp)
SELECT * FROM (SELECT temp.*,row_number() OVER(PARTITION BY JOB ORDER BY JOB,hiredate) rn FROM temp)
WHERE rn=1
UNION ALL
SELECT temp.*,1 FROM temp ORDER BY 3,5;


WITH temp AS (SELECT * FROM emp)
SELECT * FROM (SELECT temp.*,row_number() OVER(PARTITION BY JOB ORDER BY JOB,hiredate) rn FROM temp)
WHERE rn=1
UNION ALL
select temp.*,1 from temp order by JOB,HIREDATE;

SQL> select * from emp
  2  intersect
  3  select * from emp
  4  order by ename
  5  /
order by ename
         *
ERROR at line 4:
ORA-00904: "ENAME": invalid identifier

orclz> select * from dept union select * from dept order by dname;
select * from dept union select * from dept order by dname
                                                     *
ERROR at line 1:
ORA-00904: "DNAME": invalid identifier


orclz> select deptno,dname,loc from dept union select deptno,dname,loc from dept order by dname;

    DEPTNO DNAME          LOC
---------- -------------- -------------
        10 ACCOUNTING     NEW YORK
        40 OPERATIONS     BOSTON
        20 RESEARCH       DALLAS
        30 SALES          CHICAGO

orclz>