Docs Menu
Docs Home
/
MongoDB Compass
/
Interact with Your Data
/
Query

Skip a Number of Documents

If the query bar displays the Skip option, you can specify how many documents to skip before returning the result set.

Set Documents to Skip

To specify the number of documents to skip:

  1. In the Query Bar, click Options.

  2. Enter an integer representing the number of documents to skip into the Skip field.

    Results of using the Skip option
    click to enlarge

  3. Click Find to run the query and view the updated results.

    Note

    For query result sets larger than 1000 documents, Compass shows a subset of the results. Otherwise, Compass shows the entire result set.

    For details on sampling, see Sampling.

Clear the Query

To clear the query bar and the results of the query, click Reset.

How Does the Compass Query Compare to MongoDB and SQL Queries?

$skip corresponds to the LIMIT ... OFFSET ... clause in a SQL SELECT statement.

Example

You have a 3,235 articles. You would like to see a list of articles grouped in blocks of 50, starting with the 436th record.

SQL
SELECT * FROM article
LIMIT 50 OFFSET 435;
MongoDB Aggregation
db.article.aggregate(
  { $limit : 50 },
  { $skip : 435 }
);
Compass Skip Option
$skip : 435

Learn More

See the skip entry in the MongoDB Manual.

Back

Specify Collation

Next

Limit Results