Please use the form below to provide your feedback. Because your feedback is valuable to us, the information you submit in this form is recorded in our issue tracking system (JIRA), which is publicly available. You can track the status of your feedback using the ticket number displayed in the dialog once you submit the form.

A newer version of this documentation is available.

View Latest

OFFSET clause

  • reference
March 23, 2025
+ 12
The OFFSET clause specifies the number of resultset objects to skip in a SELECT query.

Purpose

When you want the resultset to skip over the first few resulting objects, use the OFFSET clause to specify that number of objects to ignore.

The LIMIT and OFFSET clauses are evaluated after the ORDER BY clause.

If a LIMIT clause is also present, the OFFSET is applied prior to the LIMIT; that is, the specified number of objects is omitted from the result set before enforcing a specified LIMIT.

Syntax

OFFSET expr
offset clause

Arguments

expr

Integer or an expression that evaluates to an integer which is non-negative.

Examples

Example 1. List 4 airport cities after skipping the first 200
n1ql
Copy
SELECT DISTINCT city
FROM `travel-sample`.inventory.airport
ORDER BY city
LIMIT 4
OFFSET 200;
Results
json
Copy
[
  {
    "city": "Brownsville"
  },
  {
    "city": "Brownwood"
  },
  {
    "city": "Brunswick"
  },
  {
    "city": "Bryan"
  }
]