Docs Home → MongoDB Compass

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
  3. Click Find to run the query and view the updated results.单击“查找”运行查询并查看更新的结果。

    Note

    For query result sets larger than 1000 documents, Compass shows a sampling of the results. 对于大于1000个文档的查询结果集，Compass会显示结果的采样。 Otherwise, Compass shows the entire result set.否则，Compass将显示整个结果集。

    For details on sampling, see Sampling.有关采样的详细信息，请参阅采样。

Clear the Query清除查询

To clear the query bar and the results of the query, click Reset.要清除查询栏和查询结果，请单击“重置”。

To Learn More了解更多信息

See the skip entry in the MongoDB Manual.请参阅MongoDB手册中的skip条目。

How Does the Compass Query Compare to MongoDB and SQL Queries?Compass查询与MongoDB和SQL查询相比如何？

$skip corresponds to the LIMIT ... OFFSET ... clause in a SQL SELECT statement.$skip对应SQL SELECT语句中的LIMIT ... OFFSET ...子句。

Example

You have a 3,235 articles. 你有3235篇文章。You would like to see a list of articles grouped in blocks of 50, starting with the 436th record.您希望看到一个以第436条记录开始的50个区块的文章列表。

SQL

SELECT * FROM article

LIMIT 50 OFFSET 435;
MongoDB AggregationMongoDB聚合

db.article.aggregate(

{ $limit : 50 },

{ $skip : 435 }

);
Compass Skip OptionCompass跳过选项

$skip : 435