INVERSE
Description
INVERSE negates the input number.
INVERSE changes the sign of the input value, i.e. effectively multiplies by -1.
One exception is the minimum integer value, which is mapped to itself (because of Two's complement).
Syntax
INVERSE ( table.column )
NULL handling
If the input value is NULL, the result is NULL as well.
Example
[1] Inverting integers and a NULL value. | ||||||||||||||
| ||||||||||||||
|
[2] Inverting the minimum value (negative) produces the minimum value (because of Two's Complement). | ||||||||
| ||||||||
|