Click or drag to resize
AggregateFunction Enumeration
Enum definition for the various aggregate functions which can be applied to fields in a retrieval query. Useful in typed lists. Use these in combination with a groupbycollection. Not all functions are legal on all fields. Some functions will produce errors when used with fields of a given type, like a Sum function with a character field. This is the responsibility of the developer. Aggregate functions are never applied to *lob fields.

Namespace:  SD.LLBLGen.Pro.ApplicationCore
Assembly:  SD.LLBLGen.Pro.ApplicationCore (in SD.LLBLGen.Pro.ApplicationCore.dll) Version: 5.3.0.0 (5.3.0)
Syntax
public enum AggregateFunction
Members
  Member nameValueDescription
None0 Default, do not apply an aggregate function to the field.
Count1 Calculates the amount of rows for the field. Results in COUNT(field)
CountDistinct2 Calculates the amount of rows with distinct values for field. Results in COUNT(DISTINCT field). Access, MySql: not supported
CountRow3 Calculates the amount of rows. Results in a COUNT(*)
Avg4 Calculates the average value for the field. Results in an AVG(field)
AvgDistinct5 Calculates the average value for the distinct values for field. Results in an AVG(DISTINCT field). Access, MySql: not supported
Max6 Calculates the max value for field. Results in a MAX(field).
Min7 Calculates the min value for field. Results in a MIN(field)
Sum8 Calculates the sum of all values of field. Results in a SUM(field)
SumDistinct9 Calculates the sum of all distinct values of field. Results in a SUM(DISTINCT field). Access, MySql: not supported
StDev10 Calculates statistical standard deviation. Results in: SqlServer: STDEV(field)
Oracle, MySql: STDDEV(field)
Access: STDEV(field)
Firebird: not supported
StDevDistinct11 Calculates statistical standard deviation over distinct values. Results in: SqlServer: not supported
Oracle: STDDEV(DISTINCT field)
Access, Firebird, MySql: not supported
Variance12 Calculates statistical variance. Results in: SqlServer: VAR(field)
Oracle, MySql: VARIANCE(field)
Access: VAR(field)
Firebird: not supported.
VarianceDistinct13 Calculates statistical variance over distinct values. Results in: SqlServer: not supported
Oracle: VARIANCE(DISTINCT field)
Access, Firebird, MySql: not supported
See Also