Skip to content

Instantly share code, notes, and snippets.

@arianvp

arianvp/gist:9116037

Last active August 29, 2015 13:56
Show Gist options
  • Save arianvp/9116037 to your computer and use it in GitHub Desktop.
Save arianvp/9116037 to your computer and use it in GitHub Desktop.
Download ZIP
Sql divisie
Raw
gistfile1.sql
SELECT id,name
FROM Driver AS D
WHERE NOT EXISTS (
SELECT *
FROM Route AS R
WHERE R.numberOfStops > 10
AND NOT EXISTS (
SELECT *
FROM Schedule AS S
WHERE S.driverID = D.id
AND S.routeID = R.id
)
)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment