ID1 ID2
---------- ----------
1 2
2 3
3 6
4 7
SQL> select t1.id1,t2.id1,sum(t2.id2) over(partition by t1.id1 order by t2.id1) from t t1,t t2 where t1.id1<=t2.id1 order by t1.id1,t2.id1;
ID1 ID1 SUM(T2.ID2)OVER(PARTITIONBYT1.ID1ORDERBYT2.ID1)
---------- ---------- -----------------------------------------------
1 1 2
1 2 5
1 3 11
1 4 18
2 2 3
2 3 9
2 4 16
3 3 6
3 4 13
4 4 7
已选择10行。
partition按t1.id1分组,在分组的时候按t2.id1排序,按每个排序的记录去分组的,所以会有上边的结果