题解 | 考试分数(五)
考试分数(五)
https://www.nowcoder.com/practice/b626ff9e2ad04789954c2132c74c0513
with p as (
select id,job,score,row_number() over(partition by job order by score desc) as t_rank,
count(*) over (partition by job) as total
from grade
)
select id,job,score,t_rank
from p
where t_rank between total/2 and total/2+1
order by id
注意这里的select 了t_rank 而不是avg（t_rank)
三环集团开奖72人在聊
你cet6就cet6，cet4就cet4，你写个cet证书等是什么意思。专业技能快赶上项目行数，你做的这2个项目哪里能提现你有这么多技能呢
