Advertisement
DimitarVasilev

Untitled

Jun 1st, 2017
66
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.71 KB | None | 0 0
  1. SELECT *
  2. FROM (SELECT first_name||' '||last_name  AS "MANAGER WITH NO MANAGER" FROM employees WHERE manager_id IS NULL),
  3. (SELECT  DISTINCT e.first_name||' '||e.last_name AS "MANAGER WITH MANAGER" FROM employees e, employees m WHERE m.manager_id=e.employee_id AND e.manager_id<>0),
  4. (SELECT  DISTINCT m.first_name||' '||m.last_name AS "EMPLOYEE WITH MANAGER" FROM employees m, employees e
  5. minus
  6. SELECT  DISTINCT e.first_name||' '||e.last_name  AS "EMPLOYEE WITH MANAGER" FROM employees e, employees m WHERE m.manager_id=e.employee_id AND e.manager_id<>0),
  7. (SELECT DISTINCT first_name||' '||last_name  AS "EMPLOYEE WITH NO MANAGER" FROM employees WHERE manager_id IS NULL AND manager_id<>employee_id)
  8. WHERE
  9. ORDER BY 1,2,3,4;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement