MongoDB – limit() and skip() method

In this we are going to learn about limit() and skip() method.

limit() method in MongoDB :

It is used to limit the response on a particular query. −

 
   
\\Syntax:- limit the number of documents

db.collection_name.find().limit(number_of_documents)

-----------------------------
-----------------------------

\\ Example
> db.employee.find().pretty()
{
        "_id" : ObjectId("59bf63380be1d7770c3982af"),
        "employee_name" : "Rajesh",
        "employee_id" : 2002,
        "employee_age" : 24
}
{
        "_id" : ObjectId("59bf63500be1d7770c3982b0"),
        "employee_name" : "Jugal",
        "employee_id" : 2003,
        "employee_age" : 25
}
{
        "_id" : ObjectId("59bf63650be1d7770c3982b1"),
        "employee_name" : "Yash",
        "employee_id" : 2004,
        "employee_age" : 23
}

\\Using limit() method to limit the documents in the result:

> db.employee.find({employee_id : {$gt:2002}}).limit(1).pretty()
{
        "_id" : ObjectId("59bf63500be1d7770c3982b0"),
        "employee_name" : "Jugal",
        "employee_id" : 2003,
        "employee_age" : 25
}

In this example the limit command is used to set the limit of the response because the limit is set to 1 so the output response is also 1.




skip() method in MongoDB :

It is used to skip the number of documents returned in the query result. . −

 
   
\\ Without using skip()
> db.employee.find({employee_id : {$gt:2002}}).limit(1).pretty()
{
        "_id" : ObjectId("59bf63500be1d7770c3982b0"),
        "employee_name" : "Jugal",
        "employee_id" : 2003,
        "employee_age" : 25
}

\\Using skip:

> db.employee.find({employee_id : {$gt:2002}}).limit(1).skip(1).pretty()
{
        "_id" : ObjectId("59bf63650be1d7770c3982b1"),
        "employee_name" : "Yash",
        "employee_id" : 2004,
        "employee_age" : 23
}

In the above example when we do not use skip than the output is employee_id: 2003, but when we use skip then the employee_id: 2003 is skipped and the output will print employee_id: 2004.






Visit :


Discussion


* You must be logged in to add comment.