Design a query using a correlated subquery that lists the highest earners for each department. Include the
Fantastic news! We've Found the answer you've been seeking!
Question:
LAST_NAME | SALARY | DEPARTMENT_ID |
---|---|---|
Hartstein | 13000 | 20 |
Mourgos | 5800 | 50 |
Hunold | 9000 | 60 |
Abel | 11000 | 80 |
Zlotkey | 10500 | 80 |
King | 24000 | 90 |
Higgins | 12000 | 110 |
Related Book For
Managerial Accounting
ISBN: 978-1259307416
16th edition
Authors: Ray Garrison, Eric Noreen, Peter Brewer
Posted Date: