SubQuery1<A> extension

Extension methods for a subquery returning zero or more rows with 1 expression.

on

Methods

count() → Expr<int>: Available on SubQuery<(Expr<A>)>, provided by the SubQuery1 extension
Count number of rows in this SubQuery using COUNT(*) aggregate function.
exists() → Expr<bool>: Available on SubQuery<(Expr<A>)>, provided by the SubQuery1 extension
Check for existance of rows in this SubQuery using EXISTS operator.
limit(int limit) → SubQuery<(Expr<A>)>: Available on SubQuery<(Expr<A>)>, provided by the SubQuery1 extension
Limit SubQuery using LIMIT clause.
offset(int offset) → SubQuery<(Expr<A>)>: Available on SubQuery<(Expr<A>)>, provided by the SubQuery1 extension
Offset SubQuery using OFFSET clause.
orderBy(List<(Expr<Comparable?>, Order)> builder(Expr<A> a)) → OrderedSubQuery<(Expr<A>)>: Available on SubQuery<(Expr<A>)>, provided by the SubQuery1 extension
Order SubQuery using ORDER BY clause.
select<T extends Record>(T projectionBuilder(Expr<A> a)) → SubQuery<T>: Available on SubQuery<(Expr<A>)>, provided by the SubQuery1 extension
Create a projection of this SubQuery using SELECT clause.
where(Expr<bool> conditionBuilder(Expr<A> a)) → SubQuery<(Expr<A>)>: Available on SubQuery<(Expr<A>)>, provided by the SubQuery1 extension
Filter SubQuery using WHERE clause.