Skip to content

Instantly share code, notes, and snippets.

@dhanish-jose

dhanish-jose/self_join.sql

Created November 20, 2016 15:48
Show Gist options
  • Save dhanish-jose/046b33d388b873e8fec5f180993c733b to your computer and use it in GitHub Desktop.
Save dhanish-jose/046b33d388b873e8fec5f180993c733b to your computer and use it in GitHub Desktop.
Download ZIP
Raw
self_join.sql
SELECT a.emp_id, a.name, a.manager_id, b.emp_id, b.name
FROM emp a, emp b
WHERE a.manager_id = b.emp_id;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment