Skip to main content

min (Aggregate Function)

Returns the minimum value for all the events.

Syntax

    <INT|LONG|DOUBLE|FLOAT> min(<INT|LONG|DOUBLE|FLOAT> arg)

QUERY PARAMETERS

NameDescriptionDefault ValuePossible Data TypesOptionalDynamic
argThe value that needs to be compared to find the minimum value.INT LONG DOUBLE FLOATNoYes

Example 1

    insert into outputStream
select min(temp) as minTemp
from inputStream;

min(temp) returns the minimum temp value recorded for all the events based on their arrival and expiry.