Limiting Records in Mongodb: Limit Records in Mongodb

Limit () method in MongoDB

To limit the records in MongoDB, you need to use the limit () method. The limit () method takes a parameter in a numeric format, which is the Document number you want to display.

Syntax

The basic limit () method syntax is as follows:

 > db . COLLECTION_NAME . find (). limit ( NUMBER ) 

For instance,

You follow Collection with the name mycol with the following data:

 { "_id" : ObjectId ( 5983548781331adf45ec5 ), "title" : "MongoDB Overview" } { "_id" : ObjectId ( 5983548781331adf45ec6 ), "title" : "NoSQL Overview" } { "_id" : ObjectId ( 5983548781331adf45ec7 ), "title" : "Tutorials Point Overview" } 

the example below shows only 2 Documents while querying.

 > db . mycol . find ({},{ "title" : 1 , _id : 0 }). limit ( 2 ) { "title" : "MongoDB Overview" } { "title" : "NoSQL Overview" } > 

If you do not specify the parameter in the limit () method, it will display all Documents from that Collection.

Skip () method in MongoDB

In addition to the limit () method, there is another method in MongoDB: skip () also takes a parameter in the numeric form and helps jump over the specified Document number.

Syntax

The basic syntax of skip () method is as follows:

 > db . COLLECTION_NAME . find (). limit ( NUMBER ). skip ( NUMBER ) 

Next lesson: Arrange records in MongoDB