- /*
-
- SQL> SELECT FIRST_NAME || ' ' || LAST_NAME AS NAME
- 2 ,SALARY,DEPARTMENT_ID
- 3 FROM EMPLOYEES
- 4 WHERE (DEPARTMENT_ID,SALARY) IN
- 5 (SELECT DEPARTMENT_ID,MAX(SALARY)
- 6 FROM EMPLOYEES
- 7 GROUP BY DEPARTMENT_ID);
-
- NAME SALARY DEPARTMENT_ID
-
- Jennifer Whalen 4400.00 10
- Michael Hartstein 13000.00 20
- Den Raphaely 11000.00 30
- Susan Mavris 6500.00 40
- Adam Fripp 8200.00 50
- Alexander Hunold 9000.00 60
- Hermann Baer 10000.00 70
- John Russell 14000.00 80
- Steven King 24000.00 90
- Nancy Greenberg 12000.00 100
- Shelley Higgins 12000.00 110
-
- 11 rows selected
|