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.
5
5
9
9
10
10
SELECT "function type" ("column_name")
11
11
FROM "table_name";
12
13
The following are examples of aggregate functions:
12
13
The following are examples of aggregate functions:
14
14
15
15
:ref:`avg`: Return the average value of the argument. (Does not work with temporal values unless first converted to numeric values.)