SQL · Numeric functions

sign()

Returns -1, 0 or 1 depending on the sign.

sqlRunnable example sql course

Syntax

sign(number)

Example

Open in the lab

SELECT sign(-7) AS sign;

Reference pages are the quick answer. The course explains the why, shows the full example and ends with a challenge.