Enum WindowFunction 

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

SQL-style window function

Variants

Lag

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

Fields

expr: Box<Expr>

offset: usize

default: Option<Box<Expr>>

Lead

LEAD(expr, offset, default) - access next row value

Fields

expr: Box<Expr>

offset: usize

default: Option<Box<Expr>>

RowNumber

ROW_NUMBER() - sequential row number in partition

Rank

RANK() - rank with gaps for ties

DenseRank

DENSE_RANK() - rank without gaps

Ntile(usize)

NTILE(n) - divide rows into n buckets

FirstValue(Box<Expr>)

FIRST_VALUE(expr) - first value in window

LastValue(Box<Expr>)

LAST_VALUE(expr) - last value in window

NthValue(Box<Expr>, usize)

NTH_VALUE(expr, n) - nth value in window

Sum(Box<Expr>)

Running aggregate functions

Avg(Box<Expr>)

Min(Box<Expr>)

Max(Box<Expr>)

Count(Option<Box<Expr>>)

Trait Implementations

impl Clone for WindowFunction

fn clone(&self) -> WindowFunction

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Debug for WindowFunction

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

Formats the value using the given formatter.

impl<'de> Deserialize<'de> for WindowFunction

fn deserialize<__D>(__deserializer: __D) -> Result<Self, __D::Error>

where __D: Deserializer<'de>,

Deserialize this value from the given Serde deserializer.

impl PartialEq for WindowFunction

fn eq(&self, other: &WindowFunction) -> 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 Serialize for WindowFunction

fn serialize<__S>(&self, __serializer: __S) -> Result<__S::Ok, __S::Error>

where __S: Serializer,

Serialize this value into the given Serde serializer.

impl StructuralPartialEq for WindowFunction