1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
|
Aggregate Functions
===================
*SQL aggregate functions are calculated from values in a column, and return a single value.*
General syntax for aggregate functions is: ::
SELECT "function type" ("column_name")
FROM "table_name"
The following are examples of aggregate functions:
* 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
* SUM() - Returns the sum
|