STDEVP (Azure Stream Analytics)
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)
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for