If you would like to upgrade to a newer long-term support version of Studio Pro, see Moving from Mendix Studio Pro 8 to 9.
OQL Aggregation
Last modified: May 29, 2024
Aggregations perform specific calculations on the values of the retrieved column(s). The following aggregate functions are possible:
| AVG | average |
|---|---|
| COUNT | count |
| MAX | maximum |
| MIN | minimum |
| SUM | sum |
When you are using an aggregate expression in the SELECT clause, all expressions in the SELECT clause have to be either an aggregation OR part in the GROUP BY clause of the query.