Useful shortcuts for vi editor

Wednesday, 12 November 2014

How to use Intersect function?

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