`OFFSET LIMIT` (NoSQL query)

The OFFSET LIMIT clause returns a subset of the result set by skipping a specified number of results and then taking a specified number of results.

Syntax

OFFSET <offset_amount> LIMIT <limit_amount>

	Description
`offset_amount`	Specifies the integer number of items that the query results should skip.
`limit_amount`	Specifies the integer number of items that the query results should include.

Returns a subset of the result set after skipping and taking the specified number of results.

This section contains examples of how to use this query language construct.

In this example, the OFFSET LIMIT clause is used to skip one result and take the next three.

SELECT VALUE {
  name: e.name
}
FROM
  employees e
WHERE
  e.team = "Leadership team"
ORDER BY
  e.name
OFFSET 1 LIMIT 3

[
  {
    "name": "Isaac Talbot"
  },
  {
    "name": "Jennifer Wilkins"
  },
  {
    "name": "Riley Johnson"
  }
]