文章目录
Sql中的over函数
窗口函数的语法:
开窗函数支持分区、排序、和框架三种元素,语法格式如下
OVER (
[ <PARTITION BY clause> ]
[ <ORDER BY clause> ]
[ <ROW or RANGE clause> ]
)
<PARTITION BY clause> ::= PARTITION BY value_expression , ... [ n ]
<ORDER BY clause> ::= ORDER BY order_by_expression [ COLLATE collation_name ] [ ASC | DESC ] [ ,...n ]
<ROW or RANGE clause> ::= { ROWS | RANGE } <window frame extent>
<window frame extent> ::= { <window frame preceding> | &