Expressions
Aggregate functions
Flow support all aggregate functions that a normal sql query supports such as COUNT
, SUM
, MIN
, MAX
, etc. For a detailed list, please refer to Aggregate Functions.
Scalar functions
Flow support all scalar functions that a normal sql query supports in our SQL reference.
And here are some of the most commonly used scalar functions in flow:
date_bin
: calculate time intervals and returns the start of the interval nearest to the specified timestamp.date_trunc
: truncate a timestamp value to a specified precision.trunc
: truncate a number to a whole number or truncated to the specified decimal places.