Edit

Share via

STDEVP (Azure Stream Analytics)

  • Article

Returns the statistical standard deviation for the population for all values in a group. Null values are ignored.

Syntax

STDEVP (expression )

Arguments

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.

Return Types

float

Examples

SELECT System.Timestamp() AS OutTime, TollId, STDEVP (Toll)   
FROM Input  
GROUP BY TollId, TumblingWindow(minute,3)