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.7.0.0 (5.7.0)
SyntaxMembers| Member name | Value | Description | |
|---|---|---|---|
| None | 0 | Default, do not apply an aggregate function to the field. | |
| Count | 1 | Calculates the amount of rows for the field. Results in COUNT(field) | |
| CountDistinct | 2 | Calculates the amount of rows with distinct values for field. Results in COUNT(DISTINCT field). Access, MySql: not supported | |
| CountRow | 3 | Calculates the amount of rows. Results in a COUNT(*) | |
| Avg | 4 | Calculates the average value for the field. Results in an AVG(field) | |
| AvgDistinct | 5 | Calculates the average value for the distinct values for field. Results in an AVG(DISTINCT field). Access, MySql: not supported | |
| Max | 6 | Calculates the max value for field. Results in a MAX(field). | |
| Min | 7 | Calculates the min value for field. Results in a MIN(field) | |
| Sum | 8 | Calculates the sum of all values of field. Results in a SUM(field) | |
| SumDistinct | 9 | Calculates the sum of all distinct values of field. Results in a SUM(DISTINCT field). Access, MySql: not supported | |
| StDev | 10 |
Calculates statistical standard deviation. Results in:
SqlServer: STDEV(field) Oracle, MySql: STDDEV(field) Access: STDEV(field) Firebird: not supported | |
| StDevDistinct | 11 |
Calculates statistical standard deviation over distinct values. Results in:
SqlServer: not supported Oracle: STDDEV(DISTINCT field) Access, Firebird, MySql: not supported | |
| Variance | 12 |
Calculates statistical variance. Results in:
SqlServer: VAR(field) Oracle, MySql: VARIANCE(field) Access: VAR(field) Firebird: not supported. | |
| VarianceDistinct | 13 |
Calculates statistical variance over distinct values. Results in:
SqlServer: not supported Oracle: VARIANCE(DISTINCT field) Access, Firebird, MySql: not supported |
See Also