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 )
点赞

相关推荐

真烦好烦真烦:牛友太有实力了
点赞 评论 收藏
分享
牛客网
牛客企业服务