简介
考察 over
从一行到另一行?? 先暂时这么记忆吧
select grade, sum(number) over(order by grade) t_rank
from class_grade
order by grade;
最差是排第几名?
Hope is a good thing,maybe the best of things,and no good thing ever dies.----------- Andy Dufresne
考察 over
从一行到另一行?? 先暂时这么记忆吧
select grade, sum(number) over(order by grade) t_rank
from class_grade
order by grade;