> ## 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 ANY_VALUE

# ANY_VALUE

Returns a single arbitrary value from the specified column.

## Syntax

```sql theme={"theme":{"light":"css-variables","dark":"css-variables"}}
ANY_VALUE(<expression>) [FILTER ([WHERE] <condition>)]
```

## Parameters

| Parameter      | Description                                                       | Supported input types |
| :------------- | :---------------------------------------------------------------- | :-------------------- |
| `<expression>` | Any expression                                                    | Any                   |
| `<condition>`  | An optional boolean expression to filter rows used in aggregation | `BOOL`                |

This function ignores `NULL` inputs. It returns `NULL` only when all inputs are `NULL` or there are no inputs.

## Return Type

Same as input type

## Examples

When multiple non-`NULL` values are present, `ANY_VALUE` returns one of them. The result is non-deterministic — different executions may return different values, but `NULL` is never returned while non-`NULL` values exist:

<div className="query-window">
  ```
  SELECT ANY_VALUE(nickname) AS any_nickname
  FROM UNNEST(ARRAY['kennethpark', NULL, 'sabrina21', 'ruthgill', 'steven70']) AS players(nickname);
  ```

  | any\_nickname <span>text null</span> |
  | :----------------------------------- |
  | kennethpark                          |

  <p><span>Rows: 1</span><span>Execution time: 9.08ms</span></p>
</div>

`ANY_VALUE` returns `NULL` when all inputs are `NULL`:

<div className="query-window">
  ```
  SELECT ANY_VALUE(data) FROM UNNEST(ARRAY[NULL, NULL, NULL]) arr(data);
  ```

  | any\_value <span>text null</span> |
  | :-------------------------------- |
  | NULL                              |

  <p><span>Rows: 1</span><span>Execution time: 8.76ms</span></p>
</div>

`ANY_VALUE` also returns `NULL` when no rows are available (for example, when filtered by a `WHERE` clause that matches nothing):

<div className="query-window">
  ```
  SELECT ANY_VALUE(data) FROM UNNEST(ARRAY[1, 2, 3]) arr(data) WHERE false;
  ```

  | any\_value <span>int null</span> |
  | :------------------------------- |
  | NULL                             |

  <p><span>Rows: 1</span><span>Execution time: 6.00ms</span></p>
</div>