Returns 1, 0, or -1 for positive, zero, or negative.
Syntax
SIGN(n)Example
Enter values below to update the example in real time.
profit→direction→financial_records→SELECT profit, SIGN(profit) AS direction FROM financial_records;
Returns 1, 0, or -1 for positive, zero, or negative.
SIGN(n)Enter values below to update the example in real time.
profit→direction→financial_records→SELECT profit, SIGN(profit) AS direction FROM financial_records;