select * from (
select *
from hr.employees
order by salary desc nulls last
) where rownum < 11| EMPLOYEE_ID | FIRST_NAME | LAST_NAME | PHONE_NUMBER | HIRE_DATE | JOB_ID | SALARY | COMMISSION_PCT | MANAGER_ID | DEPARTMENT_ID | |
|---|---|---|---|---|---|---|---|---|---|---|
| 100 | Steven | King | SKING | 515.123.4567 | 17-JUN-03 | AD_PRES | 24000 | - | - | 90 |
| 101 | Neena | Kochhar | NKOCHHAR | 515.123.4568 | 21-SEP-05 | AD_VP | 17000 | - | 100 | 90 |
| 102 | Lex | De Haan | LDEHAAN | 515.123.4569 | 13-JAN-01 | AD_VP | 17000 | - | 100 | 90 |
| 145 | John | Russell | JRUSSEL | 011.44.1344.429268 | 01-OCT-04 | SA_MAN | 14000 | .4 | 100 | 80 |
| 146 | Karen | Partners | KPARTNER | 011.44.1344.467268 | 05-JAN-05 | SA_MAN | 13500 | .3 | 100 | 80 |
| 201 | Michael | Hartstein | MHARTSTE | 515.123.5555 | 17-FEB-04 | MK_MAN | 13000 | - | 100 | 20 |
| 205 | Shelley | Higgins | SHIGGINS | 515.123.8080 | 07-JUN-02 | AC_MGR | 12008 | - | 101 | 110 |
| 108 | Nancy | Greenberg | NGREENBE | 515.124.4569 | 17-AUG-02 | FI_MGR | 12008 | - | 101 | 100 |
| 147 | Alberto | Errazuriz | AERRAZUR | 011.44.1344.429278 | 10-MAR-05 | SA_MAN | 12000 | .3 | 100 | 80 |
| 168 | Lisa | Ozer | LOZER | 011.44.1343.929268 | 11-MAR-05 | SA_REP | 11500 | .25 | 148 | 80 |