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