Member Junction
    Preparing search index...

    A row cap the query itself carries, as written.

    interface OwnRowCap {
        End: number;
        Form: "top" | "clause";
        Numeric: boolean;
        Rows: number | null;
        Skip: number;
        Start: number;
    }
    Index

    Properties

    End: number

    Offset just past the cap's text.

    Form: "top" | "clause"

    top for SELECT TOP …; clause for LIMIT / OFFSET / FETCH at the end of the statement.

    Numeric: boolean

    Whether the cap is plain integer literals, so it can be reasoned about as a row count. False for PERCENT, WITH TIES and any expression or parameter.

    Rows: number | null

    Rows the cap keeps; null when it keeps all of them (OFFSET alone, LIMIT ALL).

    Skip: number

    Rows the cap skips before keeping any.

    Start: number

    Offset in the statement where the cap's text starts.