Aggregate functions consolidate or compress the database of a complete column.
For example is it possible, from an amount of numbers to determine the average, the
minimum or the maximum. The result will be returned acted for the source data.
| Aggregate functions |
Syntax |
MIN
|
Determines the smallest value from a data record of a table column.
|
MIN( [component data_component] )
|
MAX
|
Determines the biggest value from a data record of a table column.
|
MAX( [component data_component] )
|
AVG
|
Determines the average from a data record of a table column.
|
AVG( [component data_component] )
|
SUM
|
Determines the sum from a data record of a table column.
|
SUM( [component data_component] )
|
COUNT
|
Determines the amount from a data record of a table column.
The returned value is always a number.
|
COUNT( [component data_component] )
|
FIRST
|
Determines the first data record from an amount of data records of a table column.
The returned value is equivalent to the data type of the first entry of the table column or null
if the entry contains the value null.
|
FIRST( [component data_component] )
|
LAST
|
Determines the last data record from an amount of all data records of a table column.
The returned value is equivalent to the data type of the last entry of the table column or null
if the entry contains the value null.
|
LAST( [component data_component] )
|
functions