Skip to content

Instantly share code, notes, and snippets.

@gotascii

gotascii/weird.sql

Created December 24, 2016 09:46
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 gotascii/18796a34ea6170ca25f924a8848a3c91 to your computer and use it in GitHub Desktop.
Save gotascii/18796a34ea6170ca25f924a8848a3c91 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
weird.sql
select friends.id from friends
left join line_items on (friends.id = line_items.friend_id and line_items.deleted_at is null)
where
friends.status != 'Deleted'
# MORE
select friends.id from friends
left join line_items on (friends.id = line_items.friend_id)
where
friends.status != 'Deleted'
and line_items.deleted_at is null
# LESS
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment