# Pagination

Pagination allows you to efficiently retrieve or manage large datasets by breaking them into smaller chunks (pages). It improves performance and usability for queries involving a substantial amount of data.

### How Pagination Works

Pagination is achieved by combining **limit** and **offset** parameters:

* **Limit**: Defines the maximum number of rows to retrieve.
* **Offset**: Specifies the starting point for data retrieval, effectively skipping the first `offset` rows.

By using these parameters together, you can implement pagination to load data page by page.

#### Example Use Case

Imagine a customer list with 1000 entries. To retrieve them in pages of 10:

* **Page 1**: `limit: 10, offset: 0` (Rows 1-10)
* **Page 2**: `limit: 10, offset: 10` (Rows 11-20)
* **Page 3**: `limit: 10, offset: 20` (Rows 21-30)