STDEVP (Azure Stream Analytics)
Updated: April 22, 2016
Applies To: Azure
Returns the statistical standard deviation for the population for all values in a group. Null values are ignored.
Syntax
STDEVP (expression )
expression
Is an expression of the exact numeric or approximate numeric data type category. STDEVP can be used with bigint and float columns. Aggregate functions and sub queries are not permitted.
float
SELECT System.TimeStamp AS OutTime, TollId, STDEVP (Toll) FROM Input GROUP BY TollId, TumblingWindow(minute,3)
Show: