pub enum BuiltInWindowFunction {
RowNumber,
Rank,
DenseRank,
PercentRank,
CumeDist,
Ntile,
Lag,
Lead,
FirstValue,
LastValue,
NthValue,
}
Expand description
An aggregate function that is part of a built-in window function
Variants
RowNumber
number of the current row within its partition, counting from 1
Rank
rank of the current row with gaps; same as row_number of its first peer
DenseRank
rank of the current row without gaps; this function counts peer groups
PercentRank
relative rank of the current row: (rank - 1) / (total rows - 1)
CumeDist
relative rank of the current row: (number of rows preceding or peer with current row) / (total rows)
Ntile
integer ranging from 1 to the argument value, dividing the partition as equally as possible
Lag
returns value evaluated at the row that is offset rows before the current row within the partition; if there is no such row, instead return default (which must be of the same type as value). Both offset and default are evaluated with respect to the current row. If omitted, offset defaults to 1 and default to null
Lead
returns value evaluated at the row that is offset rows after the current row within the partition; if there is no such row, instead return default (which must be of the same type as value). Both offset and default are evaluated with respect to the current row. If omitted, offset defaults to 1 and default to null
FirstValue
returns value evaluated at the row that is the first row of the window frame
LastValue
returns value evaluated at the row that is the last row of the window frame
NthValue
returns value evaluated at the row that is the nth row of the window frame (counting from 1); null if no such row
Trait Implementations
sourceimpl Clone for BuiltInWindowFunction
impl Clone for BuiltInWindowFunction
sourcefn clone(&self) -> BuiltInWindowFunction
fn clone(&self) -> BuiltInWindowFunction
1.0.0 · sourcefn clone_from(&mut self, source: &Self)
fn clone_from(&mut self, source: &Self)
source
. Read more