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