|
|
|
|
|
|
SUM_FLOAT computes the sum of an expression over a group of rows. It returns a DOUBLE PRECISION value for the expression, regardless of the expression type.
Syntax
SUM_FLOAT ( [ ALL | DISTINCT ] expression )
Semantics
ALL |
invokes the aggregate function for all rows in the group (default) |
DISTINCT |
invokes the aggregate function for all distinct non-null values of the expression found in the group |
expression |
(INTEGER, BIGINT, DOUBLE PRECISION, or INTERVAL) contains at least one |
column reference