Aggregate Functions
The following are aggregate functions for KSQL.
| Function | Example | Description |
|---|---|---|
| COUNT | COUNT(col1) | Counts the number of rows. |
| MAX | MAX(col1) | Returns the maximum value for a given column and window. |
| MIN | MIN(col1) | Returns the minimum value for a given column and window. |
| SUM | SUM(col1) | Sums the column values. |
| TOPK | TOPK(col1, K) | Returns the TopK values for the given column and window. |
| TOPKDISTINCT | TOPKDISTINCT(col1, K) | Returns the distinct TopK values for the given column and window. |