LimitClause in sqlparser::ast

LimitClause in sqlparser::ast - Rust

pub enum LimitClause {
    LimitOffset {
        limit: Option<Expr>,
        offset: Option<Offset>,
        limit_by: Vec<Expr>,
    },
    OffsetCommaLimit {
        offset: Expr,
        limit: Expr,
    },
}

Expand description

Represents the different syntactic forms of LIMIT clauses.

Standard SQL LIMIT syntax (optionally BY and OFFSET).

LIMIT <limit> [BY <expr>,<expr>,...] [OFFSET <offset>]

Fields

LIMIT { <N> | ALL } expression.

Optional OFFSET expression with optional ROW(S) keyword.

Optional BY { <expr>,... } list used by some dialects (ClickHouse).

MySQL-specific syntax: LIMIT <offset>, <limit> (order reversed).