SQL & PL/SQL

Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> WITH EMP AS
  2  (
  3  SELECT 1000 EMPNO,100 SAL FROM DUAL UNION ALL
  4  SELECT 1001,90 FROM DUAL UNION ALL
  5  SELECT 1002,80 FROM DUAL UNION ALL
  6  SELECT 1003,90 FROM DUAL UNION ALL
  7  SELECT 1004,100 FROM DUAL UNION ALL
  8  SELECT 1005,20 FROM DUAL UNION ALL
  9  SELECT 1006,10 FROM DUAL
 10  )SELECT * FROM EMP;

     EMPNO        SAL
---------- ----------
      1000        100
      1001         90
      1002         80
      1003         90
      1004        100
      1005         20
      1006         10

7 rows selected.
SQL>

     EMPNO        SAL
---------- ----------
      1000        100
      1004        100
      1001         90
      1003         90