SIGN Function

Description

The SIGN function returns the sign of a given number. It returns 1 for a positive value, -1 for a negative value, and 0 for zero.

Syntax

SIGN(number_operand)

Example

--it returns the sign of the argument

 

SELECT SIGN(12.3), SIGN(-12.3), SIGN(0);

    sign(12.3)   sign(-12.3)      sign(0)

========================================

            1            -1            0