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

> Reference material for ARRAY_DISTINCT function

# ARRAY_DISTINCT

Returns an array containing only the *unique* elements of the given array. If the given array contains multiple identical members, the returned array will include only a single member of that value. NULL is considered a value like any other, meaning that if the array contains one or more NULLs, the returned array will contain NULL.

## Syntax

```sql theme={"theme":{"light":"github-light","dark":"github-dark"}}
ARRAY_DISTINCT(<array>)
```

## Parameters

| Parameter | Description                  | Supported input types |
| :-------- | :--------------------------- | :-------------------- |
| `<array>` | The array to be deduplicated | `ARRAY`               |

## Return Type

`ARRAY` of the same type as the input array

## Example

In the following example, the unique levels of the game are returned in an array called `levels`:

```sql theme={"theme":{"light":"github-light","dark":"github-dark"}}
SELECT
	ARRAY_DISTINCT([ 1, 1, 2, 2, 3, 4, 1, NULL, 2, NULL ]) AS levels;
```

**Returns**: `[1,2,3,4,NULL]`