SIGN
Returns the sign of a number.
MySQL 8.4
SIGN(num)- num
- NumberDECIMAL
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.4
SELECT SIGN(-2);Sign of a positive number
MySQL 8.4
SELECT SIGN(2);Sign of zero
MySQL 8.4
SELECT SIGN(0);Details
Handy for splitting numbers into three groups: GROUP BY SIGN(x) counts negative, zero and positive values separately.