SQL
List Functions
<div class="nostroke_table"></div>  
|   |   |
|:--|:--------|
| **Description** |Removes all duplicates and `NULL` values from a list. Does not preserve the original order. |
| **Example** | `list_distinct([1, 1, NULL, -3, 1, 5])` |
| **Result** | `[1, 5, -3]` |
| **Alias** | `array_distinct` |