Rank(排名(Rank))¶
Supported in: Batch, Faster
Returns the rank of rows within a window partition. In case of ties the rows get same rank. The difference between rank and dense_rank is that rank leaves gaps in ranking sequence when there are ties.
Expression categories: Aggregate
Declared arguments¶
This function does not take any arguments.
Output type: Integer
中文翻译¶
排名(Rank)¶
支持:批处理(Batch)、快速处理(Faster)
返回窗口分区内各行的排名。当出现并列情况时,并列行获得相同排名。排名(rank)与密集排名(dense_rank)的区别在于:当存在并列时,排名会在排序序列中留下间隔。
表达式类别: 聚合(Aggregate)
声明参数¶
此函数不接受任何参数。
输出类型: 整数(Integer)