Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- LAST_NAME
- -------------------------
- Mourgos
- Rajs
- Davies
- Matos
- Vargas
- FIRST_NAME
- --------------------
- Randall
- Peter
- CITY
- ------------------------------
- Seattle
- LAST_NAME SALARY DEPARTMENT_ID
- ------------------------- ---------- -------------
- Gietz 8300 110
- Taylor 8600 80
- De Haan 17000 90
- Kochhar 17000 90
- LAST_NAME DEPARTMENT_ID SALARY
- ------------------------- ------------- ----------
- Matos 50 2500
- Fay 20 6000
- Lorentz 60 4200
- Vargas 50 2500
- Whalen 10 3500
- Taylor 80 8600
- 6 rows selected
- LAST_NAME SALARY
- ------------------------- ----------
- Hartstein 13000
- Higgins 12000
- Abel 11000
- Zlotkey 10500
- Hunold 9000
- Taylor 8600
- Gietz 8300
- Grant 7000
- Ernst 6000
- Fay 6000
- Mourgos 5800
- LAST_NAME SALARY
- ------------------------- ----------
- Lorentz 4200
- Rajs 3500
- Whalen 3500
- Davies 3100
- Matos 2500
- Vargas 2500
- 17 rows selected
- LAST_NAME JOB_ID SALARY
- ------------------------- ---------- ----------
- Lorentz IT_PROG 4200
- Ernst IT_PROG 6000
- Fay MK_REP 6000
- Hunold IT_PROG 9000
- DEPARTMENT_ID MIN(SALARY)
- ------------- ---------------------------------------
- 90 17000
- 110 8300
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement