为什么我写完总是不通过呢?哪位大神帮忙看看 select tag, uid, ranking from ( select tag, e_r.uid, row_number() over (partition by tag order by max(score) desc, min(score) desc, e_r.uid desc) as ranking from exam_record as e_r join examination_info as e_i on e_r.exam_id = e_r.exam_id group by tag, e_r.uid) as t where ranking <=3;
点赞

相关推荐

牛客网
牛客网在线编程
牛客网题解
牛客企业服务