For instance, you want to see same jobs for employees that belong to different manager in employees table.
Please run the sql lines in SQL Editor as "hr" user;
SELECT job_id FROM employees
WHERE manager_id = 121
INTERSECT
SELECT job_id FROM employees
WHERE manager_id = 122;
Used Database User: HR
Please run the sql lines in SQL Editor as "hr" user;
SELECT job_id FROM employees
WHERE manager_id = 121
INTERSECT
SELECT job_id FROM employees
WHERE manager_id = 122;
Used Database User: HR