Find job titles represented in every department. Write a single SELECT statement only.
Note: Use only emp table.
Expected Result: (Only clerks and managers work in all 3 departments: 10,20, and 30)
JOB -------- CLERK MANAGER
To submit your answer (one or more!) please start following this blog and add a comment to this post.
A correct answer (and workarounds!) will be published here in a week.
If you like this post, you may want to join my new Oracle group on Facebook: https://www.facebook.com/groups/sqlpatterns/
For more tricks and cool techniques check my book “Oracle SQL Tricks and Workarounds” for instructions.