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: