> ## Documentation Index
> Fetch the complete documentation index at: https://docs.omni.co/llms.txt
> Use this file to discover all available pages before exploring further.

# default_group_by

> Enables or disables a GROUP BY in the query.

This parameter is automatically set to `false` if there are no measures in the query view.

## Syntax

```yaml theme={null}
query:
  default_group_by: <true_or_false>
```

## Properties

<ParamField path="query" type="object[]">
  An object containing the individual parameters that make up a query view's query definition.

  <Expandable title="query properties" defaultOpen="true">
    <ParamField path="default_group_by" type="boolean">
      If `true`, the query will include a `GROUP BY` clause. If `false`, duplicate rows will not be grouped.

      **Note**: Omni automatically sets this to `false` if the query view does not contain any measures.
    </ParamField>
  </Expandable>
</ParamField>

## Examples

```yaml title="Group duplicate rows for users with the same name" theme={null}
query:
  fields:
    users.name: user_name
  default_group_by: true
```
