17,078
社区成员
发帖
与我相关
我的任务
分享
select t.*,row_number() over(partition by t.vcode order by t.qdate)) rn
from t
select vcode
from (select t.*,
trunc(t.qdate - row_number()
over(partition by t.vcode order by t.qdate)) rn
from t)
group by vcode, rn
having count(1) >= 3;