题解 | #考试分数(五)#
考试分数(五)
https://www.nowcoder.com/practice/b626ff9e2ad04789954c2132c74c0512
select id, job, score, d t_rank from (select *, cast(row_number()over(partition by job order by score) as signed) a, cast(row_number()over(partition by job order by score desc) as signed) d from grade ) as rk where a=d or abs(d-a)=1 order by id
同考试分数（四）
腾讯云智研发一面201人在聊
查看13道真题和解析