4
*SQL aggregate functions are calculated from values in a column, and return a single value.*
4
SQL group (aggregate) functions operate on sets of values. If you use an aggregate function in a statement containing no GROUP BY clause, it is equivalent to grouping on all rows.
6
6
General syntax for aggregate functions is: ::
8
8
SELECT "function type" ("column_name")
11
The following are examples of aggregate functions:
13
* AVG() - Returns the average value
14
* COUNT() - Returns the number of rows
15
* FIRST() - Returns the first value
16
* LAST() - Returns the last value
17
* MAX() - Returns the largest value
18
* MIN() - Returns the smallest value
19
* SUM() - Returns the sum
11
The following are examples of aggregate functions:
13
**AVG**: Return the average value of the argument. (Does not work with temporal values unless first converted to numeric values.)
15
**BIT_AND**: Return bitwise and
17
**BIT_OR**: Return bitwise or
19
**BIT_XOR**: Return bitwise xor
22
(DISTINCT): Return the count of a number of different values
24
:doc:`count`: Return a count of the number of rows returned
26
**GROUP_CONCAT**: Return a concatenated string
28
**MAX**: Return the maximum value
30
**MIN**: Return the minimum value
32
**STD**: Return the population standard deviation
34
**STDDEV_POP**: Return the population standard deviation
36
**STDDEV_SAMP**: Return the sample standard deviation
38
**STDDEV**: Return the population standard deviation
40
**SUM**: Return the sum. (Does not work with temporal values unless first converted to numeric values.)
42
**VAR_POP**: Return the population standard variance
44
**VAR_SAMP**: Return the sample variance
46
**VARIANCE**: Return the population standard variance
added
removed
docs/aggregatefunctions.rst
