Enum WindowFn 

pub enum WindowFn {
    RowNumber,
    Rank,
    DenseRank,
    Ntile(u32),
    PercentRank,
    CumeDist,
    Lag {
        expr: String,
        offset: Option<u32>,
        default: Option<String>,
    },
    Lead {
        expr: String,
        offset: Option<u32>,
        default: Option<String>,
    },
    FirstValue(String),
    LastValue(String),
    NthValue(String, u32),
    Sum(String),
    Avg(String),
    Count(String),
    Min(String),
    Max(String),
    Custom {
        name: String,
        args: Vec<String>,
    },
}

Available window functions.

Variants

RowNumber

ROW_NUMBER() - Sequential row number.

Rank

RANK() - Rank with gaps.

DenseRank

DENSE_RANK() - Rank without gaps.

Ntile(u32)

NTILE(n) - Distribute rows into n buckets.

PercentRank

PERCENT_RANK() - Relative rank (0 to 1).

CumeDist

CUME_DIST() - Cumulative distribution.

Lag

LAG(expr, offset, default) - Value from previous row.

Fields

expr: String

offset: Option<u32>

default: Option<String>

Lead

LEAD(expr, offset, default) - Value from next row.

Fields

expr: String

offset: Option<u32>

default: Option<String>

FirstValue(String)

FIRST_VALUE(expr) - First value in frame.

LastValue(String)

LAST_VALUE(expr) - Last value in frame.

NthValue(String, u32)

NTH_VALUE(expr, n) - Nth value in frame.

Sum(String)

SUM(expr).

Avg(String)

AVG(expr).

Count(String)

COUNT(expr).

Min(String)

MIN(expr).

Max(String)

MAX(expr).

Custom

Custom function.

Fields

name: String

args: Vec<String>

Implementations

impl WindowFn

pub fn to_sql(&self) -> String

Generate the function SQL.

Trait Implementations

impl Clone for WindowFn

fn clone(&self) -> WindowFn

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Debug for WindowFn

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

Formats the value using the given formatter.

impl<'de> Deserialize<'de> for WindowFn

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

where __D: Deserializer<'de>,

Deserialize this value from the given Serde deserializer.

impl PartialEq for WindowFn

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

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 WindowFn