-
Notifications
You must be signed in to change notification settings - Fork 0
Aggregate Functions
OneAndonlyFinbar edited this page Feb 19, 2022
·
3 revisions
Aggregate functions are only to be used in a select statement as the field name, several are allowed.
Aggregate functions perform a calculation on a set of values and return a single value.
The following supported aggregate functions are listed below.
| Name | Description |
|---|---|
| MAX() | Maximum value for column |
| MIN() | Minimum value for column |
| SUM() | Sum value for column |
| COUNT() | Row count |
| STDEV() | Column Standard Deviation |
| AVG() | Column Average |