GROUP BY Clause
Group SELECT result rows based on matching value rules.
The GROUP BY clause returns the output of a SELECT statement divided into groups of rows containing matching values.
Limits for GROUP BY
GROUP BY queries have a default limit of 1000 results if a limit is not otherwise specified by the user. During BETA, it is recommended that users specify a limit in queries and use a limit value of 1000 or less.
GROUP BY [ ALL | DISTINCT ] grouping_element [, ...]
The supported grouping_element syntax is as follows.
()
expression
For querying ChaosSearch index data, grouping_element is a column in the view.
Example
Updated 11 months ago