Is there any way to skip some documents in MongoDB?


Yes, you can skip some documents using skip() in MongoDB. Use limit() to display how many documents you want to display after skipping some. Let us create a collection with documents −

> db.demo682.insertOne({FirstName:"John"});
{
   "acknowledged" : true,
   "insertedId" : ObjectId("5ea462a804263e90dac94402")
}
> db.demo682.insertOne({FirstName:"Sam"});
{
   "acknowledged" : true,
   "insertedId" : ObjectId("5ea462ac04263e90dac94403")
}
> db.demo682.insertOne({FirstName:"Bob"});
{
   "acknowledged" : true,
   "insertedId" : ObjectId("5ea462af04263e90dac94404")
}
> db.demo682.insertOne({FirstName:"David"});
{
   "acknowledged" : true,
   "insertedId" : ObjectId("5ea462b304263e90dac94405")
}
> db.demo682.insertOne({FirstName:"Adam"});
{
   "acknowledged" : true,
   "insertedId" : ObjectId("5ea462ba04263e90dac94406")
}
> db.demo682.insertOne({FirstName:"Chris"});
{
   "acknowledged" : true,
   "insertedId" : ObjectId("5ea462be04263e90dac94407")
}
> db.demo682.insertOne({FirstName:"Carol"});
{
   "acknowledged" : true,
   "insertedId" : ObjectId("5ea462c404263e90dac94408")
}

Display all documents from a collection with the help of find() method −

> db.demo682.find();

This will produce the following output −

{ "_id" : ObjectId("5ea462a804263e90dac94402"), "FirstName" : "John" }
{ "_id" : ObjectId("5ea462ac04263e90dac94403"), "FirstName" : "Sam" }
{ "_id" : ObjectId("5ea462af04263e90dac94404"), "FirstName" : "Bob" }
{ "_id" : ObjectId("5ea462b304263e90dac94405"), "FirstName" : "David" }
{ "_id" : ObjectId("5ea462ba04263e90dac94406"), "FirstName" : "Adam" }
{ "_id" : ObjectId("5ea462be04263e90dac94407"), "FirstName" : "Chris" }
{ "_id" : ObjectId("5ea462c404263e90dac94408"), "FirstName" : "Carol" }

Following is the query to skip 3 documents and display 2 −

> db.demo682.find().skip(3).limit(2);

This will produce the following output −

{ "_id" : ObjectId("5ea462b304263e90dac94405"), "FirstName" : "David" }
{ "_id" : ObjectId("5ea462ba04263e90dac94406"), "FirstName" : "Adam" }

Updated on: 13-May-2020

89 Views

Kickstart Your Career

Get certified by completing the course

Get Started
Advertisements