Enum WindowFunctionType 

pub enum WindowFunctionType {
    RowNumber,
    Rank,
    DenseRank,
    NTile(u32),
    Lag {
        expr: Box<Expr>,
        offset: i64,
        default: Option<Box<Expr>>,
    },
    Lead {
        expr: Box<Expr>,
        offset: i64,
        default: Option<Box<Expr>>,
    },
    FirstValue(Box<Expr>),
    LastValue(Box<Expr>),
    NthValue(Box<Expr>, u32),
    Sum(Box<Expr>),
    Avg(Box<Expr>),
    Count(Option<Box<Expr>>),
    Min(Box<Expr>),
    Max(Box<Expr>),
}

Window function types

Variants

RowNumber

ROW_NUMBER() - assigns sequential row numbers

Rank

RANK() - assigns rank with gaps for ties

DenseRank

DENSE_RANK() - assigns rank without gaps

NTile(u32)

NTILE(n) - divides rows into n buckets

Lag

LAG(expr, offset, default) - access previous row

Fields

expr: Box<Expr>

offset: i64

default: Option<Box<Expr>>

Lead

LEAD(expr, offset, default) - access following row

Fields

expr: Box<Expr>

offset: i64

default: Option<Box<Expr>>

FirstValue(Box<Expr>)

FIRST_VALUE(expr) - first value in frame

LastValue(Box<Expr>)

LAST_VALUE(expr) - last value in frame

NthValue(Box<Expr>, u32)

NTH_VALUE(expr, n) - nth value in frame

Sum(Box<Expr>)

Aggregate function over window

Avg(Box<Expr>)

Count(Option<Box<Expr>>)

Min(Box<Expr>)

Max(Box<Expr>)

Trait Implementations

impl Clone for WindowFunctionType

fn clone(&self) -> WindowFunctionType

Returns a duplicate of the value.

fn clone_from(&mut self, source: &Self)

Performs copy-assignment from source.

impl Debug for WindowFunctionType

fn fmt(&self, f: &mut Formatter<'_>) -> Result

Formats the value using the given formatter.

impl PartialEq for WindowFunctionType

fn eq(&self, other: &WindowFunctionType) -> bool

Tests for self and other values to be equal, and is used by ==.

fn ne(&self, other: &Rhs) -> bool

Tests for !=. The default implementation is almost always sufficient, and should not be overridden without very good reason.

impl StructuralPartialEq for WindowFunctionType