Sum() Over ([Partition by ] [Order by ]
Rows Between Preceding And Following)

Sum() Over ([Partition by ] [Order by ]
Rows Between Preceding And Current Row)

Sum() Over ([Partition by ] [Order by ]
Range Between Interval '' 'Day' Preceding
And Interval '' 'Day' Following )

Dense_rank() Over ([Patition by ] [Order by ] [Nulls First/Last])

Row_number() Over ([Partitionby ] [Order by ] [Nulls First/Last])

Ntile() Over ([Partition by ] [Order by ])

具体请参考《》

四、首记录/末记录查找方面：

具体请参考《》

五、相邻记录之间比较方面：

• 上一篇：Oracle开发之报表函数下一篇：Oracle 中生成流水号的方法