Reference
Back to Remy
Remy Reference/Agent SDK/SQL database/db.skip

db.skip

Skip the first n rows (SQL OFFSET). Pairs with `take` for paging.
Query.skip(n) → Query<T[]>

Skips n rows with SQL OFFSET. Combine skip and take for offset pagination over a sorted query. For deep pages, a keyset filter on a sorted column reads faster than a large offset.

Parameters
n
number
RequiredRows to skip before taking.
Paginate
const page2 = await Posts.sortBy((p) => p.name).skip(20).take(20);