OrderedSubQueryRange2<A, B> extension

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

on

Methods

limit(int limit) OrderedSubQueryRange<(Expr<A>, Expr<B>)>

Available on OrderedSubQueryRange<(Expr<A>, Expr<B>)>, provided by the OrderedSubQueryRange2 extension

Limit OrderedSubQueryRange using LIMIT clause.
offset(int offset) OrderedSubQueryRange<(Expr<A>, Expr<B>)>

Available on OrderedSubQueryRange<(Expr<A>, Expr<B>)>, provided by the OrderedSubQueryRange2 extension

Offset OrderedSubQueryRange using OFFSET clause.
orderBy(List<(Expr<Comparable?>, Order)> builder(Expr<A> a, Expr<B> b)) OrderedSubQuery<(Expr<A>, Expr<B>)>

Available on OrderedSubQueryRange<(Expr<A>, Expr<B>)>, provided by the OrderedSubQueryRange2 extension

Order OrderedSubQueryRange using ORDER BY clause.
select<T extends Record>(T projectionBuilder(Expr<A> a, Expr<B> b)) ProjectedOrderedSubQueryRange<T>

Available on OrderedSubQueryRange<(Expr<A>, Expr<B>)>, provided by the OrderedSubQueryRange2 extension

Create a projection of this OrderedSubQueryRange using SELECT clause.