docs-v2/content/influxdb3/core/admin/distinct-value-cache/query.md

title	description	menu	weight	influxdb3/core/tags	list_code_example	related	source
Query a Distinct Value Cache	Use the [`distinct_cache()` SQL function](/influxdb3/core/reference/sql/functions/cache/#distinct_cache) in the `FROM` clause of an SQL `SELECT` statement to query data from the Distinct Value Cache.	influxdb3_core parent Manage the Distinct Value Cache	202	cache	```sql SELECT * FROM distinct_cache('table-name', 'cache-name') ``` > [!Important] > You must use SQL to query the DVC. > InfluxQL does not support the `distinct_cache()` function.	/influxdb3/core/reference/sql/functions/cache/#distinct_cache, distinct_cache SQL function	/shared/influxdb3-admin/distinct-value-cache/query.md