SIGN
Returns the sign of a number.
MySQL 8.1
SIGN(num)Parameters
- numDECIMAL
- Number
Return value
-1 for a negative number, 0 for zero, 1 for a positive number; NULL for NULL
Examples
Sign of a negative number
MySQL 8.1
SELECT SIGN(-2);Sign of a positive number
MySQL 8.1
SELECT SIGN(2);Sign of zero
MySQL 8.1
SELECT SIGN(0);Details
Handy for splitting numbers into three groups: GROUP BY SIGN(x) counts negative, zero and positive values separately.