ITPub博客

首页 > 应用开发 > IT综合 > 常用的分析函数

常用的分析函数

原创 IT综合 作者:sepulcrum 时间:2007-08-28 08:23:41 0 删除 编辑
常用的分析函数如下所列:
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 ...)[@more@]

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/10897379/viewspace-966418/,如需转载,请注明出处,否则将追究法律责任。

下一篇: RMAN MAINTENANCE
请登录后发表评论 登录
全部评论
  • 博文量
    26
  • 访问量
    169975