SubQuery8<A, B, C, D, E, F, G, H> extension
Extension methods for a subquery returning zero or more rows with 8 expressions.
Methods
-
count(
) → Expr< int> -
Available on SubQuery<
Count number of rows in this SubQuery using(Expr< , provided by the SubQuery8 extensionA> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> , Expr<H> )>COUNT(*)aggregate function. -
exists(
) → Expr< bool> -
Available on SubQuery<
Check for existance of rows in this SubQuery using(Expr< , provided by the SubQuery8 extensionA> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> , Expr<H> )>EXISTSoperator. -
limit(
int limit) → SubQuery< (Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> , Expr<H> )> -
Available on SubQuery<
Limit SubQuery using(Expr< , provided by the SubQuery8 extensionA> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> , Expr<H> )>LIMITclause. -
offset(
int offset) → SubQuery< (Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> , Expr<H> )> -
Available on SubQuery<
Offset SubQuery using(Expr< , provided by the SubQuery8 extensionA> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> , Expr<H> )>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, Expr<H> h)) → OrderedSubQuery<(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> , Expr<H> )> -
Available on SubQuery<
Order SubQuery using(Expr< , provided by the SubQuery8 extensionA> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> , Expr<H> )>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, Expr<H> h)) → SubQuery<T> -
Available on SubQuery<
Create a projection of this SubQuery using(Expr< , provided by the SubQuery8 extensionA> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> , Expr<H> )>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, Expr<H> h)) → SubQuery<(Expr< A> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> , Expr<H> )> -
Available on SubQuery<
Filter SubQuery using(Expr< , provided by the SubQuery8 extensionA> , Expr<B> , Expr<C> , Expr<D> , Expr<E> , Expr<F> , Expr<G> , Expr<H> )>WHEREclause.