在 MySQL 中,可以使用以下语句来实现统计连续三天登录的用户:
SELECT user_id
FROM login_history
WHERE login_time BETWEEN DATE_SUB(NOW(), INTERVAL 3 DAY) AND NOW()
GROUP BY user_id
HAVING COUNT(*) = 3
在 MySQL 中,可以使用以下语句来实现统计连续三天登录的用户:
SELECT user_id
FROM login_history
WHERE login_time BETWEEN DATE_SUB(NOW(), INTERVAL 3 DAY) AND NOW()
GROUP BY user_id
HAVING COUNT(*) = 3