SUM (Azure Stream Analytics)

 

Updated: April 22, 2016

Applies To: Azure

Returns the sum of all the values in the expression. SUM can be used with numeric columns only. Null values are ignored.

Syntax

SUM ( expression )  

expression

Is a constant, column, or function, and any combination of arithmetic operators. SUM can be used with bigint and float columns.

Returns the summation of all expression values in the most precise expression data type.

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

Show: