SubQuery5<A, B, C, D, E> extension
Extension methods for a subquery returning zero or more rows with 5 expressions.
Methods
-
count(
) → Expr< int> -
Available on SubQuery<
Count number of rows in this SubQuery using(Expr< , provided by the SubQuery5 extensionA> , Expr<B> , Expr<C> , Expr<D> , Expr<E> )>COUNT(*)aggregate function. -
exists(
) → Expr< bool> -
Available on SubQuery<
Check for existance of rows in this SubQuery using(Expr< , provided by the SubQuery5 extensionA> , Expr<B> , Expr<C> , Expr<D> , Expr<E> )>EXISTSoperator. -
limit(
int limit) → SubQuery< (Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> )> -
Available on SubQuery<
Limit SubQuery using(Expr< , provided by the SubQuery5 extensionA> , Expr<B> , Expr<C> , Expr<D> , Expr<E> )>LIMITclause. -
offset(
int offset) → SubQuery< (Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> )> -
Available on SubQuery<
Offset SubQuery using(Expr< , provided by the SubQuery5 extensionA> , Expr<B> , Expr<C> , Expr<D> , Expr<E> )>OFFSETclause. -
orderBy(
List< (Expr< builder(Expr<Comparable?> , Order)>A> a, Expr<B> b, Expr<C> c, Expr<D> d, Expr<E> e)) → OrderedSubQuery<(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> )> -
Available on SubQuery<
Order SubQuery using(Expr< , provided by the SubQuery5 extensionA> , Expr<B> , Expr<C> , Expr<D> , Expr<E> )>ORDER BYclause. -
select<
T extends Record> (T projectionBuilder(Expr< A> a, Expr<B> b, Expr<C> c, Expr<D> d, Expr<E> e)) → SubQuery<T> -
Available on SubQuery<
Create a projection of this SubQuery using(Expr< , provided by the SubQuery5 extensionA> , Expr<B> , Expr<C> , Expr<D> , Expr<E> )>SELECTclause. -
where(
Expr< bool> conditionBuilder(Expr<A> a, Expr<B> b, Expr<C> c, Expr<D> d, Expr<E> e)) → SubQuery<(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> )> -
Available on SubQuery<
Filter SubQuery using(Expr< , provided by the SubQuery5 extensionA> , Expr<B> , Expr<C> , Expr<D> , Expr<E> )>WHEREclause.