Loading lesson path
Concept visual
Start at both ends
Return the sign of a number:
SELECT SIGN(255.5);The SIGN() function returns the sign of a number. This function will return one of the following:
Formula
If number > 0, it returns 1
If number = 0, it returns 0
If number < 0, it returns - 1number )
Required. The number to return the sign forFrom MySQL 4.0
Return the sign of a number:
SELECT SIGN(-12);❮ MySQL Functions