Skip to content

Instantly share code, notes, and snippets.

@Teggy
Created July 25, 2008 08:24
Show Gist options
  • Save Teggy/2410 to your computer and use it in GitHub Desktop.
Save Teggy/2410 to your computer and use it in GitHub Desktop.
Flat vs. nested SQL queries (just a gist test)
select max(A)
from R
where R.B in (1,2,3,4,5,6,7,8,9,10)
select max(A)
from R
where not exists (select null
from S
where S.A = S.B)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment