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

832 B

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