GroupBy
GroupBy Function
Group the table by the specified columns.
Syntax
GroupBy(table Table, vector SelectExpression, vector GroupExpression)
Arguments
| Argument | Description |
|---|---|
table Table | Source table |
vector SelectExpression | Select expression |
vector GroupExpression | Group expression |
Examples:
GroupBy([[FusionTestTable]],array("[VarcharColumn]", "max([DateTimeCol])"),array("[VarcharColumn]"))
Returns the columns specified in the select expression group on the column specified in the group expression.This example returns the records with the latest date time value.