牛客892988599号

题解

/ 注册

全部文章 / 题解（共1篇）

题解 | #考试分数(五)#

对分数排序 with a as (select *,row_number() over(partition by job order by score desc ) ranks from grade) select a.* from a join (select job,case when rank...

Mysql

2022-01-14

1 333