# distinct

Creates a sorted list without duplicates of non-null grouped values.

```tql
distinct(xs:list) -> list
```

## Description

The `distinct` function returns a sorted list containing unique, non-null values in `xs`.

### `xs: list`

The values to deduplicate.

## Examples

### Get distinct values in a list

```tql
from {x: 1}, {x: 2}, {x: 2}, {x: 3}
summarize unique=distinct(x)
```

```tql
{unique: [1, 2, 3]}
```

## See Also

* [`collect`](https://preview.docs.tenzir.com/375/375/reference/functions/collect.md)
* [`count_distinct`](https://preview.docs.tenzir.com/375/375/reference/functions/count_distinct.md)
* [`value_counts`](https://preview.docs.tenzir.com/375/375/reference/functions/value_counts.md)
* [Aggregate event streams](https://preview.docs.tenzir.com/375/375/guides/analytics/aggregate-event-streams.md)