Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT employees.JOB_ID, jobs.JOB_TITLE, FIRST_NAME,SALARY
- FROM employees
- JOIN jobs ON employees.JOB_ID = jobs.JOB_ID
- WHERE employees.JOB_ID
- IN(
- SELECT employees.JOB_ID
- FROM employees
- GROUP BY employees.JOB_ID)
- GROUP BY employees.JOB_ID
- ORDER BY SALARY DESC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement