count()不计算空值呀,为什么还要限定where submit_time is not null,求大佬解答,我筛选条件是这么写的也能通过where uid in( select uid from exam_record group by uid Having count(submit_time)/count(distinct date_format(submit_time,'%Y%m'))>=3 )
点赞

相关推荐

在考古的丘比特很冷艳:[牛泪我横向一周多自动挂了,面试答的还行,感觉挂的莫名其妙
点赞 评论 收藏
分享
牛客网
牛客网在线编程
牛客网题解
牛客企业服务