Struct WindowSpec 

pub struct WindowSpec {
    pub partition_by: Option<Vec<Expression>>,
    pub order_by: Option<Vec<OrderByItem>>,
    pub frame: Option<WindowFrame>,
}

Window specification (OVER clause)

Fields

partition_by: Option<Vec<Expression>>

PARTITION BY clause - divides rows into partitions Example: PARTITION BY department_id

order_by: Option<Vec<OrderByItem>>

ORDER BY clause - defines order within each partition Example: ORDER BY salary DESC, hire_date

frame: Option<WindowFrame>

Frame clause - defines which rows are included in the window frame Example: ROWS BETWEEN 2 PRECEDING AND CURRENT ROW

Trait Implementations

impl Clone for WindowSpec

fn clone(&self) -> WindowSpec

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Debug for WindowSpec

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

Formats the value using the given formatter.

impl PartialEq for WindowSpec

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

fn to_sql(&self) -> String

Convert this AST node to a SQL string

impl StructuralPartialEq for WindowSpec