[MySQL]日付け指定による重複確認

LINEで送る
Pocket

select count(id),user_id from daily_active_user where login_date >= '2018-06-18' and login_date < '2018-06-19' group by user_id,login_date having count(id) >= 2 limit 20;
+-----------+---------+
| count(id) | user_id |
+-----------+---------+
|         4 |       0 |
+-----------+---------+
1 row in set (9.05 sec)

Was this helpful?

0 / 0

コメントを残す 0

Your email address will not be published. Required fields are marked *