题解 | #最差是第几名(二)#
最差是第几名(二)
https://www.nowcoder.com/practice/165d88474d434597bcd2af8bf72b24f1
select grade from ( select grade ,sum(number) over() total, sum(number) over(order by grade) a, #升序排列 sum(number) over(order by grade desc) b #降序排列 from class_grade)aa where a>=(total/2) and b>=(total/2) #取a，b值大于等于总数二分之一的交集位置 order by grade
