1> select * from qq_emp2 
     order by dnum 
     
     

+-------------+------+---------------+---------------+--------------------+-------------------------+
|id           |dnum  |fname          |lname          |salary              |sdate                    |
+-------------+------+---------------+---------------+--------------------+-------------------------+
|           70|3200  |SANJEEV        |TYAGI          |           $13000.00|23-jul-1996              |
|           61|3200  |QING-QING      |FAN            |            $6250.00|30-jul-1996              |
|           83|3200  |SHOBHA         |MURTHY         |            $4750.00|23-dec-1996              |
|           17|4200  |JUDITH         |CLOSE          |           $10000.00|21-aug-1995              |
|           49|4200  |KANWAL         |RAHMAN         |            $8000.00|30-oct-1995              |
|           85|4200  |ELIZABETH      |BAILEY         |            $4500.00|15-dec-1995              |
|           51|4200  |HAOPING        |TAI            |            $6250.00|31-dec-1995              |
|           56|4200  |SEONGWOOK      |KWON           |            $6250.00|31-jan-1997              |
|           23|4200  |MARCIE         |COLLEDGE       |            $7500.00|30-sep-1997              |
|           11|4200  |LIRONG         |ZHANG          |            $7879.00|31-oct-1997              |
|           88|4200  |XIN            |WEI            |           $10261.50|31-oct-1997              |
|           13|4500  |I-CHEN         |SUN            |            $3000.00|31-mar-1997              |
|           73|4900  |MIRIAM         |URIZAR         |            $5400.00|31-mar-1997              |
|           51|4900  |JOSEFINA       |BONILLA        |            $1333.50|31-may-1997              |
|           20|4900  |TRONG          |NGUYEN         |            $5070.00|31-may-1998              |
|           32|5200  |DONALD         |RICE           |            $7000.00|30-apr-1995              |
+-------------+------+---------------+---------------+--------------------+-------------------------+
(16 rows)
End of Request