MULT
Description
The multiplication operator computes the product of two values.
The multiplication operator can be applied to INT or FLOAT columns or constants. The resulting column is of type INT if both input columns or constants are of type INT. In all other cases, the resulting column is of type FLOAT.
Syntax
MULT ( table.column1 , table.column2 )
table.column1 * table.column2
NULL handling
If one of the input values is NULL, the result is NULL as well.
Examples
[1] | ||||||||||||||
| ||||||||||||||
|
[2] Multiply a column of type FLOAT with a constant FLOAT value: | ||||||||||||||
| ||||||||||||||
|
[3] | ||||||||||||||
| ||||||||||||||
|
[4] | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||||||||||||||||||||
|