题解 | 查询连续登陆的用户

SELECT 
    user_id
FROM
    register_tb r
WHERE EXISTS(
        SELECT 1 FROM login_tb l1 WHERE l1.user_id = r.user_id AND EXISTS(
            SELECT 1 FROM login_tb l2 
            WHERE DATEDIFF(l1.log_time,l2.log_time) = 1 AND l2.user_id = l1.user_id AND EXISTS(
                SELECT 1 FROM login_tb l3 
                WHERE DATEDIFF(l2.log_time,l3.log_time) = 1 AND l3.user_id = l2.user_id 
            )
        )
    )
ORDER BY
    user_id