OFFSETclause specifies the number of resultset objects to skip in a
(Introduced in Couchbase Server 4.0)
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.
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