Advertisement
clydeee

SQL Exam

Aug 22nd, 2019
99
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.13 KB | None | 0 0
  1. SELECT COUNT(1) as log_count FROM
  2. (
  3. SELECT userid
  4. FROM i_user_login_logs
  5. GROUP BY userid
  6. HAVING (COUNT(userid) > 3)
  7. ) AS derived
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement