SQL语句问题 ROWS BETWEEN

[lookat800]

SUM(ZSJCZ) OVER(PARTITION BY XXXXX order BY XXXXXX ROWS BETWEEN CURRENT ROW AND CURRENT ROW)
谁能告诉我ROWS BETWEEN CURRENT ROW AND CURRENT ROW是啥意思？ROWS BETWEEN 的用法？

[dgjejdcf]

帮顶

[seapexjiang]

rows between ... and ... 意思是：在XXX之前和XXX之后的所有记录

[norno]

http://www.devx.com/getHelpOn/10MinuteSolution/16573/1954?pf=true

推荐看下OLAP几个常用函数的用法

[zongjun_zhang]

http://www.itpub.net/thread-1089340-1-6.html
DB2 V9.5 ROWNUMBER/RANK 学习笔记

[jr-create(•̀⌄•́)]

ROWS BETWEEN CURRENT ROW AND CURRENT ROW 就是当前行的意思

1、sum(cost) over(partition by name order by orderdate rows between current row and UNBOUNDED FOLLOWING ) as sample7 --当前行及后面所有行聚合

2、sum(cost) over(partition by name order by orderdate rows between 1 PRECEDING AND 1 FOLLOWING ) as sample6,--当前行和前面一行及后面一行聚合

3、sum(cost) over(partition by name order by orderdate rows between UNBOUNDED PRECEDING and current row ) as sample4 ,--和 sample3 一样,由起点到当前行的聚合

4、sum(cost) over(partition by name order by orderdate rows between 1 PRECEDING and current row) as sample5, --当前行和前面一行做聚合

 

 

CURRENT ROW：当前行

n PRECEDING：往前 n 行数据

n FOLLOWING：往后 n 行数据

UNBOUNDED：起点，

UNBOUNDED PRECEDING  表示从前面的起点，

UNBOUNDED FOLLOWING 表示到后面的终点