AggregateFunction Enumeration |
Namespace: SD.LLBLGen.Pro.ORMSupportClasses
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(*) | |
CountBig | 4 | Calculates the amount of rows for the field. Results in COUNT(field) and returns an Int64. SQL Server 2005+ | |
CountBigDistinct | 5 | Calculates the amount of rows with distinct values for field. Results in COUNT(DISTINCT field) and returns an Int64. SQL Server 2005+ Access, MySql: not supported | |
CountBigRow | 6 | Calculates the amount of rows. Results in a COUNT(*) and returns an Int64. SQL Server 2005+ | |
Avg | 7 | Calculates the average value for the field. Results in an AVG(field) | |
AvgDistinct | 8 | Calculates the average value for the distinct values for field. Results in an AVG(DISTINCT field). Access, MySql: not supported | |
Max | 9 | Calculates the max value for field. Results in a MAX(field). | |
Min | 10 | Calculates the min value for field. Results in a MIN(field) | |
Sum | 11 | Calculates the sum of all values of field. Results in a SUM(field) | |
SumDistinct | 12 | Calculates the sum of all distinct values of field. Results in a SUM(DISTINCT field). Access, MySql: not supported | |
StDev | 13 |
Calculates statistical standard deviation. Results in:
SqlServer: STDEV(field) Oracle, MySql: STDDEV(field) Access: STDEV(field) Firebird: not supported | |
StDevDistinct | 14 |
Calculates statistical standard deviation over distinct values. Results in:
SqlServer: not supported Oracle: STDDEV(DISTINCT field) Access, Firebird, MySql: not supported | |
Variance | 15 |
Calculates statistical variance. Results in:
SqlServer: VAR(field) Oracle, MySql: VARIANCE(field) Access: VAR(field) Firebird: not supported. | |
VarianceDistinct | 16 |
Calculates statistical variance over distinct values. Results in:
SqlServer: not supported Oracle: VARIANCE(DISTINCT field) Access, Firebird, MySql: not supported |