1.分析
sum over用法,先对grade排序,然后依次计算各个sum。
2.代码
select grade, sum(number) over(order by grade) t_rank from class_grade order by grade;
1.分析
sum over用法,先对grade排序,然后依次计算各个sum。
2.代码
select grade, sum(number) over(order by grade) t_rank from class_grade order by grade;