Skip to content

Instantly share code, notes, and snippets.

@t-ob

t-ob/bad.sql

Created August 1, 2012 17:04
Show Gist options
  • Save t-ob/3228826 to your computer and use it in GitHub Desktop.
Save t-ob/3228826 to your computer and use it in GitHub Desktop.
Download ZIP
bad tweets
Raw
bad.sql
select count(*), tweet_id, content, max(screen_name), max(created_at), min(screen_name), min(created_at)
from tweets_with_id
group by tweet_id
having count(*) = 2
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment