Advertisement
Guest User

Untitled

a guest
Mar 22nd, 2018
75
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.26 KB | None | 0 0
  1. SELECT screen_name, substring(member_since,1,12) as data_corta from users where data_corta in (SELECT substring(member_since,1,12) as data_corta
  2. FROM users
  3. GROUP BY data_corta
  4. HAVING COUNT(*)>50)
  5.  
  6.  
  7. return:
  8. Unknown column 'dd' in 'IN/ALL/ANY subquery'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement