2026/8/25 5:47:43
连续登陆三天及以上的用户(经典SQL面试题)
可以使用“日期减去行号”的间隔分组法。先对同一用户同一天的重复登录去重:
WITH login_distinct AS (SELECT DISTINCTuser_id,CAST(login_date AS DATE) AS login_dateFROM login
),numbered AS (SELECTuser_id,login_date,ROW_NUMBER() OVER (PARTITION BY user_…