AVG (Azure Stream Analytics)

 

Updated: April 22, 2016

Applies To: Azure

Returns the average of the values in a group. Null values are ignored.

Syntax

AVG (expression )  

expression

Is an expression of the exact numeric or approximate numeric data type category. AVG can be used with bigint and float columns. Aggregate functions and sub queries are not permitted.

The return type is determined by the type of the evaluated result of expression.

SELECT System.TimeStamp AS OutTime, TollId, AVG (Toll)   
FROM Input TIMESTAMP BY EntryTime  
GROUP BY TollId, TumblingWindow(minute,3)  
  

Show: