Struct Select

pub struct Select {

    pub distinct: Option<Distinct>,
    pub top: Option<Top>,
    pub projection: Vec<SelectItem>,
    pub into: Option<SelectInto>,
    pub from: Vec<TableWithJoins>,
    pub lateral_views: Vec<LateralView>,
    pub selection: Option<Expr>,
    pub group_by: GroupByExpr,
    pub cluster_by: Vec<Expr>,
    pub distribute_by: Vec<Expr>,
    pub sort_by: Vec<Expr>,
    pub having: Option<Expr>,
    pub named_window: Vec<NamedWindowDefinition>,
    pub qualify: Option<Expr>,
    pub value_table_mode: Option<ValueTableMode>,
}

A restricted variant of SELECT (without CTEs/ORDER BY), which may appear either as the only body item of a Query, or as an operand to a set operation like UNION.

Fields

distinct: Option<Distinct>

top: Option<Top>

MSSQL syntax: TOP (<N>) [ PERCENT ] [ WITH TIES ]

projection: Vec<SelectItem>

projection expressions

into: Option<SelectInto>

INTO

from: Vec<TableWithJoins>

FROM

lateral_views: Vec<LateralView>

LATERAL VIEWs

selection: Option<Expr>

WHERE

group_by: GroupByExpr

GROUP BY

cluster_by: Vec<Expr>

CLUSTER BY (Hive)

distribute_by: Vec<Expr>

DISTRIBUTE BY (Hive)

sort_by: Vec<Expr>

SORT BY (Hive)

having: Option<Expr>

HAVING

named_window: Vec<NamedWindowDefinition>

WINDOW AS

qualify: Option<Expr>

QUALIFY (Snowflake)

value_table_mode: Option<ValueTableMode>

BigQuery syntax: SELECT AS VALUE | SELECT AS STRUCT

Trait Implementations

impl Clone for Select

fn clone(&self) -> Select

Returns a copy of the value.

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

Performs copy-assignment from source.

impl Debug for Select

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

Formats the value using the given formatter.

impl Display for Select

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

Formats the value using the given formatter.

impl Hash for Select

fn hash<__H>(&self, state: &mut __H)

where __H: Hasher,

Feeds this value into the given Hasher.

fn hash_slice<H>(data: &[Self], state: &mut H)

where H: Hasher, Self: Sized,

Feeds a slice of this type into the given Hasher.

impl Ord for Select

fn cmp(&self, other: &Select) -> Ordering

This method returns an Ordering between self and other.

fn max(self, other: Self) -> Self

where Self: Sized,

Compares and returns the maximum of two values.

fn min(self, other: Self) -> Self

where Self: Sized,

Compares and returns the minimum of two values.

fn clamp(self, min: Self, max: Self) -> Self

where Self: Sized,

Restrict a value to a certain interval.

impl PartialEq for Select

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

fn partial_cmp(&self, other: &Select) -> Option<Ordering>

This method returns an ordering between self and other values if one exists.

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

Tests less than (for self and other) and is used by the < operator.

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

Tests less than or equal to (for self and other) and is used by the <= operator.

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

Tests greater than (for self and other) and is used by the > operator.

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

Tests greater than or equal to (for self and other) and is used by the >= operator.

impl Eq for Select

impl StructuralPartialEq for Select