Powered by GitBook

1 of 1

Loading...

SIGN

Return the sign of a number. This function returns -1, 0, or 1 depending on whether the argument is negative, zero, or positive.

Syntax

SIGN(X)

Description

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

Examples

See Also

_{This page is licensed: GPLv2, originally from}

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

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

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