This function is used to return the additive inverse of a.
Syntax
negative(INT a)
Parameters
Parameter |
Mandatory |
Type |
Description |
|---|---|---|---|
a |
Yes |
DOUBLE, BIGINT, DECIMAL, or STRING |
The value can be a float, integer, or string. |
Return Values
The return value is of the DECIMAL or INT type.
If the value of a is NULL, NULL is returned.
Example Code
The value -1 is returned.
SELECT negative(1);
The value 3 is returned.
SELECT negative(-3);