Oracle 常用的剖析开窗函数ITeye - AG环亚娱乐

Oracle 常用的剖析开窗函数ITeye

2019-01-11 02:22:09 | 作者: 旭鹏 | 标签: | 浏览: 2603

ROW_NUMBER() OVER(PARTITION BY ... ORDER BY ...) RANK() OVER(PARTITION BY ... ORDER BY ...) DENSE_RANK() OVER(PARTITION BY ... ORDER BY ...) COUNT() OVER(PARTITION BY ... ORDER BY ...) MAX() OVER(PARTITION BY ... ORDER BY ...) MIN() OVER(PARTITION BY ... ORDER BY ...) SUM() OVER(PARTITION BY ... ORDER BY ...) AVG() OVER(PARTITION BY ... ORDER BY ...) FIRST_VALUE() OVER(PARTITION BY ... ORDER BY ...) LAST_VALUE() OVER(PARTITION BY ... ORDER BY ...) LAG() OVER(PARTITION BY ... ORDER BY ...) LEAD() OVER(PARTITION BY ... ORDER BY ...)

 

版权声明
本文来源于网络,版权归原作者所有,其内容与观点不代表AG环亚娱乐立场。转载文章仅为传播更有价值的信息,如采编人员采编有误或者版权原因,请与我们联系,我们核实后立即修改或删除。

猜您喜欢的文章