# uniqExact (/docs/reference/sql/aggregate-functions/uniqexact)



This page describes the RawTree engine binary used to generate this reference. It does not define Query API support. Descriptions retain upstream ClickHouse terminology. See [SQL interface scope](/docs/reference/clickhouse-compatibility#service-interfaces).

Calculates the exact number of different argument values.

:::warning
The `uniqExact` function uses more memory than `uniq`, because the size of the state has unbounded growth as the number of different values increases.
Use the `uniqExact` function if you absolutely need an exact result.
Otherwise use the [`uniq`](/reference/functions/aggregate-functions/uniq) function.
:::

**Syntax**

```sql
uniqExact(x[, ...])
```

**Arguments**

* `x` — The function takes a variable number of parameters. [`Tuple(T)`](/reference/data-types/tuple) or [`Array(T)`](/reference/data-types/array) or [`Date`](/reference/data-types/date) or [`DateTime`](/reference/data-types/datetime) or [`String`](/reference/data-types/string) or [`(U)Int*`](/reference/data-types/int-uint) or [`Float*`](/reference/data-types/float) or [`Decimal`](/reference/data-types/decimal)

**Returned value**

Returns the exact number of different argument values as a UInt64. [`UInt64`](/reference/data-types/int-uint)

**Examples**

**Basic usage**

```sql title=Query
CREATE TABLE example_data
(
    id UInt32,
    category String
)
ENGINE = Memory;

INSERT INTO example_data VALUES
(1, 'A'), (2, 'B'), (3, 'A'), (4, 'C'), (5, 'B'), (6, 'A');

SELECT uniqExact(category) as exact_unique_categories
FROM example_data;
```

```text title=Response
┌─exact_unique_categories─┐
│                       3 │
└─────────────────────────┘
```

**Multiple arguments**

```sql title=Query
SELECT uniqExact(id, category) as exact_unique_combinations
FROM example_data;
```

```text title=Response
┌─exact_unique_combinations─┐
│                         6 │
└───────────────────────────┘
```

*Introduced in version 1.1.0.*
