Skip to content

Instantly share code, notes, and snippets.

@xmeng1

xmeng1/workers.sql

Forked from kenjipm/workers.sql
Created August 14, 2019 10:43
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save xmeng1/e33401c6f1f6b3baa50da916418a5fa4 to your computer and use it in GitHub Desktop.
Save xmeng1/e33401c6f1f6b3baa50da916418a5fa4 to your computer and use it in GitHub Desktop.
Download ZIP
The following data definition defines an organization's employee hierarchy. An employee is a manager if any other employee has their managerId set to the first employees id. An employee who is a manager may or may not also have a manager. TABLE employees id INTEGER NOT NULL PRIMARY KEY managerId INTEGER REFERENCES employees(id) name VARCHAR(30) …
Raw
workers.sql
SELECT name FROM employees
WHERE id NOT IN (SELECT managerId FROM employees WHERE managerId IS NOT NULL);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment