# Lavorare intorno al limite di 10.000 risultati di Data Explorer?

**URL:** https://meta.discourse.org/t/working-around-the-10-000-result-limit-of-data-explorer/315395
**Category:** Data & reporting
**Tags:** data-explorer, sql-query
**Created:** [26 Giugno 2024, 4:11pm UTC](https://meta.discourse.org/t/working-around-the-10-000-result-limit-of-data-explorer/315395 "2024-06-26T16:11:52Z")
**Posts on this page:** 1
**Showing post:** 2

<div class="post-metadata">

### Author: ![JammyDodger](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/jammydodger/32/254611_2.png) [@JammyDodger](https://meta.discourse.org/u/JammyDodger)
#### Post date: [26 Giugno 2024, 4:29pm UTC](https://meta.discourse.org/t/working-around-the-10-000-result-limit-of-data-explorer/315395/2 "2024-06-26T16:29:17Z")

</div>

Per query più grandi, puoi aggiungere la paginazione ed ottenere batch che possono essere uniti “off-site”. Qualcosa come:

```sql
--[params]
-- integer :limit = 10000
-- integer :page = 0

SELECT
    id,
    title
FROM topics
WHERE visible = false
ORDER BY id
OFFSET :page * :limit
LIMIT :limit

```

---

_[View the full topic](https://meta.discourse.org/t/working-around-the-10-000-result-limit-of-data-explorer/315395)._