欢迎投稿

今日深度:

oarcle sum函数与sum() over(partition by ... order by ... ),

oarcle sum函数与sum() over(partition by ... order by ... ),


sum()函数就不介绍了。

sum() over(partition by ... order by ... )其实就是累加的过程具体化。

比如 有1,2,3,4

sum()就会得到10

sum() over(partition by ... order by ... ) 就会得到:1,3,6,10。



www.htsjk.Com true http://www.htsjk.com/teradata/35936.html NewsArticle oarcle sum函数与sum() over(partition by ... order by ... ), sum()函数就不介绍了。 sum() over(partition by ... order by ... )其实就是累加的过程具体化。 比如 有1,2,3,4 sum()就会得到10 sum() over(partition...
相关文章
    暂无相关文章
评论暂时关闭