# 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:** 2\
**Page:** 1

<div class="post-metadata">

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

</div>

When using SQL for queries, it is not allowed to use 'Limit 10 OFFSET 20' in MySQL; Or "Limit 20, 10; Is that so?

---

<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!