题解 | #最差是第几名(二)#
最差是第几名(二)
http://www.nowcoder.com/practice/165d88474d434597bcd2af8bf72b24f1
应该是子表最少的查询代码,使用三个窗口函数
锁定中位数关键思路见链接
select grade from (select grade,sum(NUMBER) over(order by grade) AS t_rank, sum(NUMBER) over(order by grade DESC) AS t_rank2, sum(number) over() as tot FROM class_grade) t1 where t_rank >=tot/2 and t_rank2 >= tot/2 ORDER by grade