有没大佬看下我这个为什么自测通过提交不行呢?谢谢! with t1 as (select uid,max(score) max_score from exam_record left join examination_info using(exam_id) group by uid) select uid,level,register_time,max_score from user_info left join t1 using(uid) where uid in (select uid from exam_record left join user_info using(uid) where job='算法' and date_format(register_time,'%Y%m')=date_format(submit_time,'%Y%m')) order by max_score desc limit 6,3
点赞

相关推荐

许愿求offer:要有钩子,项目描述里必须有一两个让面试官忍不住想问的技术点
点赞 评论 收藏
分享
牛客网
牛客网在线编程
牛客网题解
牛客企业服务