# Limit, Offset, and Pagination

## limit

| Name  | Type    | Required | Default | Description                    |
| ----- | ------- | -------- | ------- | ------------------------------ |
| value | numeric | `true`   |         | The limit value for the query. |

Sets the limit value for the query.

{% code title="QueryBuilder" %}

```javascript
query.from( "users" )
    .limit( 5 );
```

{% endcode %}

{% code title="MySQL" %}

```sql
SELECT *
FROM `users`
LIMIT 5
```

{% endcode %}

## take

| Name  | Type    | Required | Default | Description                    |
| ----- | ------- | -------- | ------- | ------------------------------ |
| value | numeric | `true`   |         | The limit value for the query. |

Sets the limit value for the query.  Alias for [`limit`](#limit).

{% code title="QueryBuilder" %}

```javascript
query.from( "users" )
    .take( 5 );
```

{% endcode %}

{% code title="MySQL" %}

```sql
SELECT *
FROM `users`
LIMIT 5
```

{% endcode %}

## offset

| Name  | Type    | Required | Default | Description                     |
| ----- | ------- | -------- | ------- | ------------------------------- |
| value | numeric | `true`   |         | The offset value for the query. |

Sets the offset value for the query.

{% code title="QueryBuilder" %}

```javascript
query.from( "users" )
    .offset( 25 );
```

{% endcode %}

{% code title="MySQL" %}

```sql
SELECT *
FROM `users`
OFFSET 25
```

{% endcode %}

## forPage

| Name    | Type    | Required | Default | Description                                                                            |
| ------- | ------- | -------- | ------- | -------------------------------------------------------------------------------------- |
| page    | numeric | `true`   |         | The page number to retrieve.                                                           |
| maxRows | numeric | `true`   |         | The number of records per page.  If a number less than 0 is passed, 0 is used instead. |

Helper method to calculate the limit and offset given a page number and count per page.

{% code title="QueryBuilder" %}

```javascript
query.from( "users" )
    .forPage( 3, 15 );
```

{% endcode %}

{% code title="MySQL" %}

```sql
SELECT *
FROM `users`
LIMIT 15
OFFSET 30
```

{% endcode %}

## simplePaginate & paginate

This method combines `forPage`, `count`, and `get` to create a pagination struct alongside the results. Information on the `simplePaginate` or `paginate` methods, including custom pagination collectors, can be found in the [Retreiving Results](https://qb.ortusbooks.com/8.8.0/executing-queries/retrieving-results#paginate) section of the documentation.