日期:2014-05-17  浏览次数:20782 次

Oracle开发专题之:分析函数总结(转载)

这一篇是对前面所有关于分析函数的文章的总结:

一、统计方面:

Sum()?Over?([Partition?by?]?[Order?by?])

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?([