题解 | #最差是第几名(二)#
最差是第几名(二)
https://www.nowcoder.com/practice/165d88474d434597bcd2af8bf72b24f1
#利用正序和逆序进行排列
select
grade
from
(
select
grade
,(select sum(number) from class_grade) cnt
,sum(number)over(order by grade) t1
,sum(number)over(order by grade desc) t2
from class_grade
)table1
where t1 >= cnt/2 and t2>= cnt/2
order by 1
投递华为等公司10个岗位 >