MssqlAggregate class
An aggregate expression, optionally evaluated over a window.
resultType records the SQL type without forcing Dart numeric constraints.
- Inheritance
-
- Object
- MssqlExpression
- MssqlAggregate
- Implemented types
- Available extensions
- Annotations
-
- @immutable
Constructors
- MssqlAggregate.avg(MssqlExpression operand, {MssqlIntegerAverage? integers, int exactScale = 6, bool distinct = false})
-
AVG(x).factory - MssqlAggregate.count(MssqlExpression operand, {bool distinct = false})
-
COUNT(x): the number of non-null values.factory - MssqlAggregate.countBig(MssqlExpression operand, {bool distinct = false})
-
COUNT_BIG(x), for a count that can pass 2^31.factory - MssqlAggregate.max(MssqlExpression operand)
-
MAX(x).factory - MssqlAggregate.min(MssqlExpression operand)
-
MIN(x), over anything SQL Server can order.factory - MssqlAggregate.sum(MssqlExpression operand, {bool distinct = false})
-
SUM(x).factory
Properties
- distinct → bool
-
SUM(DISTINCT x).final - function → MssqlAggregateFunction
-
final
- hashCode → int
-
The hash code for this object.
no setterinherited
- operand → MssqlExpression
-
final
- resultType → MssqlColumnType?
-
SQL result type, or null when the operand type is unknown.
final
- runtimeType → Type
-
A representation of the runtime type of the object.
no setterinherited
- window → MssqlWindow?
-
The
OVER (…)clause, or null for an ordinary grouped aggregate.final
Methods
-
as(
String alias) → MssqlAliased -
Available on MssqlExpression, provided by the MssqlExpressionOperators extension
Gives this expression a result alias. -
asc(
{MssqlNulls? nulls}) → MssqlOrder -
Available on MssqlExpression, provided by the MssqlExpressionOperators extension
Orders by this expression, ascending. -
between(
Object? lower, Object? upper) → MssqlCondition -
Available on MssqlExpression, provided by the MssqlExpressionOperators extension
-
betweenColumns(
String lower, String upper) → MssqlCondition -
Available on MssqlExpression, provided by the MssqlExpressionOperators extension
BETWEENtwo other columns rather than two values. -
compile(
MssqlParameterAllocator parameters, MssqlDialect dialect) → String -
Writes this expression's SQL, binding any values through
parameters.override -
desc(
{MssqlNulls? nulls}) → MssqlOrder -
Available on MssqlExpression, provided by the MssqlExpressionOperators extension
Orders by this expression, descending. -
eq(
Object? value) → MssqlCondition -
Available on MssqlExpression, provided by the MssqlExpressionOperators extension
-
eqCol(
String identifier) → MssqlCondition -
Available on MssqlExpression, provided by the MssqlExpressionOperators extension
Compares this expression to another column rather than to a value. -
eqExpr(
MssqlExpression other) → MssqlCondition -
Available on MssqlExpression, provided by the MssqlExpressionOperators extension
Compares this expression to another expression. -
gt(
Object? value) → MssqlCondition -
Available on MssqlExpression, provided by the MssqlExpressionOperators extension
-
gte(
Object? value) → MssqlCondition -
Available on MssqlExpression, provided by the MssqlExpressionOperators extension
-
inList(
Iterable< Object?> values) → MssqlCondition -
Available on MssqlExpression, provided by the MssqlExpressionOperators extension
-
inQuery(
MssqlSelectQuery query) → MssqlCondition -
Available on MssqlExpression, provided by the MssqlSubqueryExpressionOperators extension
-
isNotNull(
) → MssqlCondition -
Available on MssqlExpression, provided by the MssqlExpressionOperators extension
-
isNull(
) → MssqlCondition -
Available on MssqlExpression, provided by the MssqlExpressionOperators extension
-
lt(
Object? value) → MssqlCondition -
Available on MssqlExpression, provided by the MssqlExpressionOperators extension
-
lte(
Object? value) → MssqlCondition -
Available on MssqlExpression, provided by the MssqlExpressionOperators extension
-
ne(
Object? value) → MssqlCondition -
Available on MssqlExpression, provided by the MssqlExpressionOperators extension
-
noSuchMethod(
Invocation invocation) → dynamic -
Invoked when a nonexistent method or property is accessed.
inherited
-
notBetween(
Object? lower, Object? upper) → MssqlCondition -
Available on MssqlExpression, provided by the MssqlExpressionOperators extension
-
notBetweenColumns(
String lower, String upper) → MssqlCondition -
Available on MssqlExpression, provided by the MssqlExpressionOperators extension
-
notInList(
Iterable< Object?> values) → MssqlCondition -
Available on MssqlExpression, provided by the MssqlExpressionOperators extension
-
notInQuery(
MssqlSelectQuery query) → MssqlCondition -
Available on MssqlExpression, provided by the MssqlSubqueryExpressionOperators extension
-
over(
MssqlWindow window) → MssqlAggregate -
Returns this aggregate evaluated over
window. -
toString(
) → String -
A string representation of this object.
inherited
-
whereAfterToday(
) → MssqlCondition -
Available on MssqlExpression, provided by the MssqlExpressionOperators extension
-
whereBeforeToday(
) → MssqlCondition -
Available on MssqlExpression, provided by the MssqlExpressionOperators extension
-
whereDate(
Object? value, [MssqlOperator operator = MssqlOperator.eq]) → MssqlCondition -
Available on MssqlExpression, provided by the MssqlExpressionOperators extension
Compares the date alone, so the whole day matches rather than midnight. -
whereDay(
int value, [MssqlOperator operator = MssqlOperator.eq]) → MssqlCondition -
Available on MssqlExpression, provided by the MssqlExpressionOperators extension
-
whereFuture(
) → MssqlCondition -
Available on MssqlExpression, provided by the MssqlExpressionOperators extension
-
whereMonth(
int value, [MssqlOperator operator = MssqlOperator.eq]) → MssqlCondition -
Available on MssqlExpression, provided by the MssqlExpressionOperators extension
-
whereNowOrFuture(
) → MssqlCondition -
Available on MssqlExpression, provided by the MssqlExpressionOperators extension
-
whereNowOrPast(
) → MssqlCondition -
Available on MssqlExpression, provided by the MssqlExpressionOperators extension
-
wherePast(
) → MssqlCondition -
Available on MssqlExpression, provided by the MssqlExpressionOperators extension
Strictly earlier than now, again by the server's clock. -
whereTime(
Object? value, [MssqlOperator operator = MssqlOperator.eq]) → MssqlCondition -
Available on MssqlExpression, provided by the MssqlExpressionOperators extension
Compares the time of day, with the date discarded. -
whereToday(
) → MssqlCondition -
Available on MssqlExpression, provided by the MssqlExpressionOperators extension
The date part equals today, as the server reckons it. -
whereTodayOrAfter(
) → MssqlCondition -
Available on MssqlExpression, provided by the MssqlExpressionOperators extension
-
whereTodayOrBefore(
) → MssqlCondition -
Available on MssqlExpression, provided by the MssqlExpressionOperators extension
-
whereYear(
int value, [MssqlOperator operator = MssqlOperator.eq]) → MssqlCondition -
Available on MssqlExpression, provided by the MssqlExpressionOperators extension
Operators
-
operator ==(
Object other) → bool -
The equality operator.
inherited