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: