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: