跳转至

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)