RetroSearch Browse

Home - News ( United States | United Kingdom | Italy | Germany ) - Football scores

Showing content from https://www.geeksforgeeks.org/python/python-mongodb-limit-query/ below:

Python MongoDB - Limit Query

Last Updated : 15 Jul, 2025

In PyMongo, the limit() method is used to restrict the number of documents returned by a query. It’s especially useful when you want to preview only a few records from a large dataset.

Syntax

collection.find().limit(n)

Parameter: n (int) is the maximum number of documents to return.

Here is our sample data. Python


 from pymongo import MongoClient
c = MongoClient("mongodb://localhost:27017/")
db = c['grpDB']
col = db['sales']

data = [
    {"_id": 1, "user": "Amit", "product": "Pen", "amount": 5},
    {"_id": 2, "user": "Drew", "product": "Pencil", "amount": 3},
    {"_id": 3, "user": "Amit", "product": "Notebook", "amount": 15},
    {"_id": 4, "user": "Cody", "product": "Pen", "amount": 7},
    {"_id": 5, "user": "Drew", "product": "Notebook", "amount": 12},
    {"_id": 6, "user": "Cody", "product": "Eraser", "amount": 2},
    {"_id": 7, "user": "Amit", "product": "Pen", "amount": 10}
]

col.delete_many({})
col.insert_many(data)
print("Data inserted.")

Output

Data inserted.

Sample data

Explanation:

MongoClient() connects to the MongoDB server running on localhost at the default port 27017.
delete_many({}) clears any existing documents from the collection to prevent duplicate entries.
insert_many(data) inserts the list of sample documents into the collection.

Examples Example 1: Limit to first 3 documents Python


 #Driver Code Starts
from pymongo import MongoClient
c = MongoClient("mongodb://localhost:27017/")
db = c['grpDB']
col = db['sales']

#Driver Code Ends

res = col.find().limit(3)
for doc in res:

#Driver Code Starts
    print(doc)
#Driver Code Ends

Output

First 3 docs

Explanation: find().limit(3) returns only the first 3 documents from the collection.

Example 2: Combine with sort Python


 from pymongo import MongoClient
c = MongoClient("mongodb://localhost:27017/")
db = c['grpDB']
col = db['sales']

res = col.find().sort("amount", -1).limit(2)
for doc in res:
    print(doc)

Output

Top 2 by amount

Explanation: Sorts the documents by amount in descending order and limits the output to the top 2.

Example 3: Limit results based on a filter Python


 from pymongo import MongoClient
c = MongoClient("mongodb://localhost:27017/")
db = c['grpDB']
col = db['sales']

res = col.find({"user": "Cody"}).limit(1)
for doc in res:
    print(doc)

Output

First Cody record

Explanation: Filters documents where user is "Cody" and limits the result to just 1 document (the first match based on insertion order).

Related Articles

MongoDB Aggregation Pipeline

Python MongoDB

Insert and Update Data Query

How to Setup MongoDB with Python on Localhost

RetroSearch is an open source project built by @garambo | Open a GitHub Issue

Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo

HTML: 3.2 | Encoding: UTF-8 | Version: 0.7.4