SQL aggregate functions return a single value, calculated from values in a column.
| Function | Description |
|---|---|
| AVG() | Returns the average value |
| COUNT() | Returns the number of rows |
| FIRST() | Returns the first value |
| LAST() | Returns the last value |
| MAX() | Returns the largest value |
| MIN() | Returns the smallest value |
| ROUND() | Rounds a numeric field to the number of decimals specified |
| SUM() | Returns the sum |
EmoticonEmoticon