Section: Projection, sort, and page

Offset pagination

javascript
javascript
db.orders.find().sort({ created_at: -1 }).skip(40).limit(20)
Explanation

Offset pagination is easy to understand but can become less efficient for very large offsets.

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Related commands

Same sheet · prioritizing Projection, sort, and page
Limit result size
Return only a fixed number of documents.
OpenIn sheetjavascriptsame section
Cursor-style pagination idea
Use a stable sort key such as `_id` or a timestamp.
OpenIn sheetjavascriptsame section
Project selected fields
Return only specific fields from matches.
OpenIn sheetjavascriptsame section
Sort newest first
Sort descending on a field.
OpenIn sheetjavascriptsame section
Comparison operators
Filter with range operators.
OpenIn sheetjavascript1 tag match
Match a list of values
Filter using `$in`.
OpenIn sheetjavascript1 tag match