跳到主要内容

SIGN

Returns the sign of the argument as -1, 0, or 1, depending on whether X is negative, zero, or positive or NULL if the argument was NULL.

Syntax

SIGN(X)

Arguments

ArgumentsDescription
XThe numerical value.

Return Type

A i8 data type value.

Examples

SELECT SIGN(NULL);
+------------+
| SIGN(NULL) |
+------------+
| NULL |
+------------+

SELECT SIGN(0);
+---------+
| SIGN(0) |
+---------+
| 0 |
+---------+

SELECT SIGN(10);
+----------+
| SIGN(10) |
+----------+
| 1 |
+----------+

SELECT SIGN(-10);
+--------------+
| SIGN((- 10)) |
+--------------+
| -1 |
+--------------+