Skip to content

Instantly share code, notes, and snippets.

@hoffm
Created September 11, 2013 16:32
Show Gist options
  • Save hoffm/6526233 to your computer and use it in GitHub Desktop.
Save hoffm/6526233 to your computer and use it in GitHub Desktop.
What the relationship between the output of line 1 and the output of line 2?
SELECT COUNT(*) FROM `shipments` WHERE (status != 'delivered')
SELECT COUNT(*) FROM `shipments` WHERE (status IS NULL OR status != 'delivered')
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment