OrderedSubQuery8<A, B, C, D, E, F, G, H> extension

Extension methods for a ordered subquery of zero or more rows with 8 expressions.

on

Methods

limit(int limit) → OrderedSubQueryRange<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>, Expr<H>)>

Available on OrderedSubQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>, Expr<H>)>, provided by the OrderedSubQuery8 extension

Limit OrderedSubQuery using LIMIT clause.
offset(int offset) → OrderedSubQueryRange<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>, Expr<H>)>

Available on OrderedSubQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>, Expr<H>)>, provided by the OrderedSubQuery8 extension

Offset OrderedSubQuery using OFFSET clause.
orderBy(List<(Expr<Comparable?>, Order)> builder(Expr<A> a, Expr<B> b, Expr<C> c, Expr<D> d, Expr<E> e, Expr<F> f, Expr<G> g, Expr<H> h)) → OrderedSubQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>, Expr<H>)>

Available on OrderedSubQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>, Expr<H>)>, provided by the OrderedSubQuery8 extension

Order OrderedSubQuery using ORDER BY clause.
select<T extends Record>(T projectionBuilder(Expr<A> a, Expr<B> b, Expr<C> c, Expr<D> d, Expr<E> e, Expr<F> f, Expr<G> g, Expr<H> h)) → ProjectedOrderedSubQuery<T>

Available on OrderedSubQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>, Expr<H>)>, provided by the OrderedSubQuery8 extension

Create a projection of this OrderedSubQuery using SELECT clause.
where(Expr<bool> conditionBuilder(Expr<A> a, Expr<B> b, Expr<C> c, Expr<D> d, Expr<E> e, Expr<F> f, Expr<G> g, Expr<H> h)) → OrderedSubQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>, Expr<H>)>

Available on OrderedSubQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>, Expr<H>)>, provided by the OrderedSubQuery8 extension

Filter OrderedSubQuery using WHERE clause.