SELECT id ,MAX(date2) last_date FROM (SELECT id,date2,last_day,DATEDIFF(DAY,last_day,date2) gap FROM (SELECT id,date2, MAX(date2) OVER(PARTITION BY id order by date2 ROWS BETWEEN 1 PRECEDING AND 1 PRECEDING ) last_day FROM DS) TMD )TMD1 GROUP BY id HAVING MAX(gap)>=5;

相关推荐

不愿透露姓名的神秘牛友
07-25 15:14
点赞 评论 收藏
分享
牛客网
牛客网在线编程
牛客网题解
牛客企业服务