题解 | 考试分数(四)
考试分数(四)
https://www.nowcoder.com/practice/502fb6e2b1ad4e56aa2e0dd90c6edf3c
select job,floor((max(rk)+1)/2) as start, ceil((max(rk)+1)/2) as end from (select job,score, row_number() over(partition by job order by score DESC) as rk from grade) as A group by job order by job
