MIN (Azure Stream Analytics)

 

Updated: April 22, 2016

Applies To: Azure

Returns the minimum value in the expression.

Syntax

MIN ( expression )  

expression

Is a constant, column name, or function, and any combination of arithmetic operators. MIN can be used with bigint and float 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, MIN (Toll)   
FROM Input TIMESTAMP BY EntryTime  
GROUP BY TollId, TumblingWindow(minute,3)  
  

Show: