select distinct shop_no from(select a.shop_no,a.order_date from Table a inner join Table b on a.shop_no=b.shop_no and a.order_date>=b.order_date and a.order_date<=b.order_date+2 where b.order_num>100 group by 1,2 having count(*)=3)

相关推荐

头像
03-26 13:44
南华大学 Java
在看面经的花生米很野蛮:这种情况下你当然要回答,你也是吗!!!!我超喜欢他的XXXXX
点赞 评论 收藏
分享
牛客网
牛客企业服务