April 2008
Intermediate to advanced
566 pages
21h 55m
English
SIGN()
SIGN(number)This function returns –1 if the given number is a negative, 0 if it is zero, and 1 if it is positive. Here is an example:
SELECT SIGN(-5); +----------+ | SIGN(-5) | +----------+ | -1 | +----------+
Read now
Unlock full access