MAX (Azure Stream Analytics)

 

Updated: April 22, 2016

Applies To: Azure

Returns the maximum value in the expression.

Syntax

MAX ( expression )  

expression

Is a constant, column name, or function, and any combination of arithmetic operators. MAX can be used with bigint and float columns, but not with bit columns. Aggregate functions and subqueries are not permitted.

Returns a value same as expression.

If payload schema was not defined with CREATE TABLE statement and type of the result expression is unknown at query compilation time, return value will have float type.

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

Show: