第二题;汉窗口函数找差就行(随笔),请大佬多多指教。 select t.uid from( select uid, login_date, row_number()over(partition by uid order by login_date) as m from table ) as t group by uid,subdate(t.login_date,t.m) having count(uid)>=5