SIGN
Description
Returns the sign of x. Negative, zero or positive numbers correspond to -1, 0 or 1 respectively.
Syntax
SIGN(x)Parameters
| Parameter | Description |
|---|---|
<x> | independent variable |
Return value
Returns an integer:
-
If x > 0, it returns 1, representing a positive number.
-
If x = 0, it returns 0, representing zero.
-
If x < 0, it returns -1, representing a negative number.
-
If x is NULL, it returns NULL.
Example
select sign(3);+-------------------------+
| sign(cast(3 as DOUBLE)) |
+-------------------------+
| 1 |
+-------------------------+select sign(0);+-------------------------+
| sign(cast(0 as DOUBLE)) |
+-------------------------+
| 0 |
+-------------------------+select sign(-10.0);+-----------------------------+
| sign(cast(-10.0 as DOUBLE)) |
+-----------------------------+
| -1 |
+-----------------------------+select sign(null);+------------+
| sign(NULL) |
+------------+
| NULL |
+------------+