# sql Pagination Query

**URL:** <https://discuss.elastic.co/t/sql-pagination-query/367237>\
**Category:** Elasticsearch\
**Created:** [September 27, 2024, 10:52am UTC](https://discuss.elastic.co/t/sql-pagination-query/367237 "2024-09-27T10:52:02Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![carly.richmond](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/carly.richmond/32/104935_2.png) [@carly.richmond](https://discuss.elastic.co/u/carly.richmond)\
**Post date:** [September 27, 2024, 10:56am UTC](https://discuss.elastic.co/t/sql-pagination-query/367237/2 "2024-09-27T10:56:09Z")

</div>

Hi @mengpeiyao,

Welcome! I assume you are using the Elasticsearch SQL capabilities? I see from [this open issue](https://github.com/elastic/elasticsearch/issues/31549) and [forum post](https://discuss.elastic.co/t/how-to-use-pagination-in-elastic-search-sql/191135) that OFFSET is not supported.

Since it looks like you're trying to do pagination I would recommend following [this approach where you pass back the cursor ID](https://www.elastic.co/guide/en/elasticsearch/reference/current/sql-pagination.html) from the [initial request](https://www.elastic.co/guide/en/elasticsearch/reference/current/sql-rest-format.html).

Hope that helps!

---

_[View the full topic](https://discuss.elastic.co/t/sql-pagination-query/367237)._