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