Example 1: Query SELECT SIGN(-2);
The following query returns the result -1.
SELECT SIGN(-2);
Example 2: Query Results When the Value is an Integer and Equal to 0
The following query returns the result 0 since the value is an integer and equal to 0.
SELECT SIGN(CAST(0 AS INTEGER));
Example 3: Query Results When the data type is FLOAT and the value is >= 0
The following query returns the result 1 since the data type is FLOAT and the value is >= 0.
SELECT SIGN(CAST(0 as FLOAT));
Example 4: Query SELECT SIGN(3.74);
The following query returns the result 1.
SELECT SIGN(3.74);