Lesson menuPython TutorialHideShow

Python Tutorial

Python MongoDB - Sort

Order query results ascending or descending, on one field or many.

← MongoDB QueryMongoDB Delete →

sort()

Chain .sort() onto a find cursor. Use 1 for ascending and -1 for descending.

from pymongo import MongoClient

client = MongoClient("mongodb://localhost:27017/")
customers = client["mydatabase"]["customers"]

for doc in customers.find().sort("name"):        # ascending (default)
    print(doc["name"])

for doc in customers.find().sort("name", -1):    # descending
    print(doc["name"])

Sort by Multiple Fields

Pass a list of (field, direction) tuples. Order matters: earlier fields take precedence.

from pymongo import ASCENDING, DESCENDING

cursor = customers.find().sort([
    ("age", ASCENDING),
    ("name", DESCENDING),
])
# youngest first; within the same age, names Z -> A

ASCENDING is just 1 and DESCENDING is -1. The named constants make intent clearer.

Sort With Limit: Top N

Combine sort and limit to get the top results efficiently.

top3 = client["shop"]["products"].find().sort("price", -1).limit(3)
for p in top3:
    print(p["name"], p["price"])   # three most expensive products

Skip for Pagination

page, per_page = 2, 10
cursor = (customers.find()
          .sort("name")
          .skip((page - 1) * per_page)
          .limit(per_page))
# rows 11-20 in name order

Large skip values are slow — MongoDB still walks the skipped documents. For deep pagination, filter by the last seen value (range/keyset pagination) instead.

Sorting Needs Indexes at Scale

Sorting many documents without a supporting index forces an in-memory sort, which MongoDB caps at 100 MB. Create an index on the sort fields for large collections.

customers.create_index([("age", 1), ("name", -1)])   # supports the sort above

Best Practices

  • Use the ASCENDING/DESCENDING constants for readability.
  • Index the fields you sort on — in the same order and direction.
  • Pair sort with limit for efficient top-N queries.
  • Avoid huge skip offsets; prefer keyset pagination.

Try It Yourself

Exercise 1: Return the 3 newest documents (highest _id first).

Show solution
coll.find().sort("_id", -1).limit(3)

Exercise 2: What do the values 1 and −1 mean in sort?

Show solution

1 = ascending, −1 = descending.

📘 Real-World Deep Dive

Knowing <strong>MongoDB Sort (MongoDB)</strong> well is what turns MongoDB from a curiosity into a daily tool — you'll reach for it in nearly every real project.

Real-Life Scenario

An end-to-end usage of MongoDB Sort that you'd actually see in a data pipeline or analytics notebook.

Real-Life Example

from pymongo import MongoClient
db = MongoClient().shop
for u in db.users.find().sort("created_at", -1).limit(3):
    print(u["email"])

Expected Output

(see source)

Common mistakes

  • Inserting a dict with embedded datetime works, but naive datetime (without UTC) leads to subtle comparison bugs.
  • Queries with type-mismatched values silently return no results — cast at the boundary or use bson codecs.
  • find() returns a cursor — call list(cursor) only once you intend to materialise results.
  • Treating MongoDB Sort as a black box without reading the docs — the API has subtle defaults that bite when you scale.

🚀 Performance & Best Practices

  • Project only the fields you need: collection.find({}, {"name": 1}).
  • Use bulk_write instead of looping over single inserts / updates — order-of-magnitude faster.
  • Create indexes: collection.create_index([("field", pymongo.ASCENDING)]).
  • When working with MongoDB, prefer vectorised / batched operations over Python loops.

🧪 Try It Yourself

  1. Reproduce the snippet on a representative slice of your own data.
  2. Profile the snippet with cProfile or timeit and find the single biggest improvement.
  3. Generalise the snippet into a small, reusable function you can drop into future projects.

FAQ: Python MongoDB - Sort

Common questions about this page.

What is Python MongoDB - Sort?

Python MongoDB - Sort is a MongoDB lesson that explains python mongodb - sort in MongoDB. Order query results ascending or descending, on one field or many. Copy the samples and run them in the MongoDB editor. It is written for beginners who want a clear definition and working examples.

Should I run python mongodb - sort examples locally for better learning?

Yes. Use the browser editor on StudyGrid for a quick check, then Download the example and run it on your computer. Local runs show real errors and the real toolchain, which is one of the fastest ways to learn python mongodb - sort in this MongoDB MongoDB lesson (Python MongoDB - Sort).

How do I use python mongodb - sort in MongoDB?

To use python mongodb - sort in MongoDB, follow the examples on this StudyGrid page. Copy a snippet, run it in the browser, then Download and run it locally for better learning. Change the values and compare the output.

What is the syntax of python mongodb - sort?

This Python MongoDB - Sort tutorial shows python mongodb - sort syntax with short MongoDB examples. Use the code blocks in this lesson for the exact statements, then try them in your editor.

Python MongoDB - Sort example for beginners

Yes. This page includes a beginner python mongodb - sort example you can copy and run. It is designed for searches such as "python mongodb - sort for beginners", "python mongodb - sort example", and "how to use python mongodb - sort".

What are common mistakes with python mongodb - sort?

Common python mongodb - sort mistakes include wrong syntax, mixing types, and skipping practice. Work through this MongoDB chapter in order, run every example, and check the output before moving on.

Why should I learn python mongodb - sort?

Python MongoDB - Sort is used in real MongoDB work. Learning python mongodb - sort helps you write clearer programs and continue the MongoDB tutorial on StudyGrid.

Is Python MongoDB - Sort free to learn online?

Yes. You can learn python mongodb - sort free on StudyGrid (studygrid.in). This chapter is part of the MongoDB path and includes examples, syntax, and next-step links.