---
schema_version: "1"
id: 838379d42ae01de33342b7f59805e456cfe3ad6a95a9c7ca3be14b48f06f2eb1
title: ARRAY_DISTINCT
collection: developer
version: current
locale: en-us
portal_url: https://docs.salesforce.com/developer/current/en-us/data-cloud/data-cloud-query-guide/references/data-cloud-sql-reference/scalar-func/array-func/array-distinct.md
canonical_url: https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/array-distinct.html
source_site: developer.salesforce.com
content_type: documentation
content_hash: 6f2ffdaa5012c82b1f448869c46c35b538237d8b593288dfba8ef411278b3b83
products:
  - Data 360 Query Guide
  - Data 360 Developer Documentation
---
# `ARRAY_DISTINCT`

**Applies to:** ✅ Data 360 SQL ✅ Tableau Hyper API

Returns an array with duplicate elements removed, preserving the first occurrence of each element.

## Syntax

```sql
array_distinct(<array>)
```

## Arguments

### Required

- `<array>`: The source array.

## Returns

Returns an array that contains only unique elements, with the first occurrence of each element preserved.

## Considerations

- Keeps only the first occurrence of each duplicate element.
- Preserves the relative order of elements.

## Examples

### Remove Duplicates

Get unique values from an array with duplicates.

```sql
SELECT array_distinct(array[1, 2, 1, 3]) AS result;
```

Returns `array[1, 2, 3]`, removing the duplicate 1 and keeping the first occurrence.

## Related Documentation

- [Array Data Type](https://developer.salesforce.com/docs/data/data-cloud-query-guide/datatype/array.md)