> ## Documentation Index
> Fetch the complete documentation index at: https://docs.cube.dev/llms.txt
> Use this file to discover all available pages before exploring further.

# Implementing pagination

> Recipe for paged tables over Cube queries using `limit`, `offset`, and deterministic ordering on a sample orders model.

## Use case

We want to display a table of data with hundreds of rows. To make the table
easier to digest and to improve the performance of the query, we'll use
pagination. With the recipe below, we'll get the orders list sorted by the order
number. Every page will have 5 orders.

## Data modeling

We have the following data model:

<CodeGroup>
  ```yaml title="YAML" theme={"dark"}
  cubes:
    - name: orders
      sql_table: orders

      measures:
        - name: count
          type: count

      dimensions:
        - name: number
          sql: number
          type: number

        - name: created_at
          sql: created_at
          type: time
  ```

  ```javascript title="JavaScript" theme={"dark"}
  cube(`orders`, {
    sql_table: `orders`,

    measures: {
      count: {
        type: `count`
      }
    },

    dimensions: {
      number: {
        sql: `number`,
        type: `number`
      },

      created_at: {
        sql: `created_at`,
        type: `time`
      }
    }
  })
  ```
</CodeGroup>

## Query

To select orders that belong to a particular page, we can use the `limit` and
`offset` query properties. First, let's get the number of all orders that we
have.

```json theme={"dark"}
{
  "measures": ["orders.count"]
}
```

Then, let's retrieve first batch (page) of five orders:

```json theme={"dark"}
{
  "dimensions": ["orders.number"],
  "order": {
    "orders.number": "asc"
  },
  "limit": 5
}
```

Now, let's retrieve the second batch (page) of five orders:

```json theme={"dark"}
{
  "dimensions": ["orders.number"],
  "order": {
    "orders.number": "asc"
  },
  "limit": 5,
  "offset": 5
}
```

## Result

We have received five orders per query and can use them as we want.

```javascript theme={"dark"}
// Orders count:

[
  {
    "orders.count": "10000"
  }
]
```

```javascript theme={"dark"}
// The first five orders:

[
  {
    "orders.number": 1
  },
  {
    "orders.number": 2
  },
  {
    "orders.number": 3
  },
  {
    "orders.number": 4
  },
  {
    "orders.number": 5
  }
]
```

```javascript theme={"dark"}
// The next five orders:

[
  {
    "orders.number": 6
  },
  {
    "orders.number": 7
  },
  {
    "orders.number": 8
  },
  {
    "orders.number": 9
  },
  {
    "orders.number": 10
  }
]
```

## Source code

Please feel free to check out the
[full source code](https://github.com/cube-js/cube/tree/master/examples/recipes/pagination)
or run it with the `docker-compose up` command. You'll see the result, including
queried data, in the console.