Skip to content

Instantly share code, notes, and snippets.

@tdmitch

tdmitch/NotInWithNull_V2.sql

Created June 16, 2020 03:03
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 tdmitch/4e9098f2583eb4911c5bdf4557e37d57 to your computer and use it in GitHub Desktop.
Save tdmitch/4e9098f2583eb4911c5bdf4557e37d57 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
NotInWithNull_V2.sql
-- Show cars with a type other than 'Coupe' or NULL. Corrected to account for NULLs.
SELECT *
FROM #Automobiles
WHERE AutoType NOT IN ('Coupe')
AND AutoType IS NOT NULL
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment