Enum AggregateType

Namespace

YndigoBlue.Velocity.Enums

Assembly

YndigoBlue.Velocity.dll

Specifies SQL aggregate functions for summarizing data.

public enum AggregateType

Fields

Count = 1

Counts the number of rows or non-NULL values.

Sum = 2

Calculates the sum of numeric values.

Average = 3

Calculates the arithmetic mean of numeric values.

Min = 4

Returns the minimum value.

Max = 5

Returns the maximum value.

StdDev = 6

Calculates the standard deviation of numeric values.

Variance = 7

Calculates the variance of numeric values.

Remarks

Aggregate functions perform calculations on a set of values and return a single value. They are commonly used with GROUP BY clauses to summarize data.