Guest User

Untitled

a guest
Feb 21st, 2018
87
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.19 KB | None | 0 0
  1. SELECT la.*
  2. FROM   log_accounts la
  3. WHERE  la.userid IN
  4.     (
  5.            SELECT   la_.userid
  6.            AS       userid_
  7.             FROM     log_accounts la_
  8.             GROUP BY userid_
  9.             HAVING   COUNT( * ) >= 3
  10.      );
Add Comment
Please, Sign In to add comment