SIGN (Azure Stream Analytics)
Published: November 2, 2015
Updated: April 22, 2016
Applies To: Azure
A mathematical function that returns the positive (+1), zero (0), or negative (-1) sign of the specified expression.
Syntax
SIGN (expression)
expression
Is an expression of the exact numeric or approximate numeric data type category.
Returns the same type as submitted in expression.
SELECT SIGN(input.x) AS "The SIGN of the variable x" FROM input
Show: