扫码加入数据分析学习群

1.rows between 1 preceding and 1 following 窗口范围是分区中的前一行、当前行、后一行共三行记录

2.rows between 1 preceding and current row 窗口范围是分区中的前一行、当前行共两行记录

3.rows between current row and 1 following 窗口范围是分区中当前行、后一行共两行记录

4.rows unbounded preceding 窗口范围是分区中第一行到当前行

5.rows between unbounded preceding and current row 窗口范围是分区中的第一行到当前行

6.rows between current row and unbounded following 窗口范围是分区中当前行到最后一行

7.rows between unbounded preceding and unbounded following 窗口范围是当前分区中的所有行，等同于不写