题解 | #牛客每个人最近的登录日期(三)#
考试分数(三)
http://www.nowcoder.com/practice/b83f8b0e7e934d95a56c24f047260d91
两表自连接，where子句配合having count(distinct g2.score)<3得到分组后score的dense_rank前两位排名 select g1.id,name,g1.score from grade g1,grade g2,language l where g1.language_id=g2.language_id and g1.score<=g2.score and g1.language_id=l.id group by g1.id,g1.language_id having count(distinct g2.score)<3 order by name asc,g1.score desc,g1.id asc
阿里云成长空间 753人发布
实际上你做了之后根本不想刷题
