Skip to content

Instantly share code, notes, and snippets.

@vvgsrk

vvgsrk/self_join.sql

Created October 18, 2021 19:10
Show Gist options
  • Save vvgsrk/79d0836268c775e59b635e0d4150d478 to your computer and use it in GitHub Desktop.
Save vvgsrk/79d0836268c775e59b635e0d4150d478 to your computer and use it in GitHub Desktop.
Download ZIP
Self Join
Raw
self_join.sql
SELECT worker.last_name || ' works for ' || manager.last_name worker_works_for_manager
FROM employees worker, employees manager
WHERE worker.manager_id = manager.employee_id;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment