sort method ascending and descending in MongoDB

Introduction

Sorting helps you organize data so you can find what you need faster. You can put data in order from smallest to largest or largest to smallest.

When you want to see a list of products from cheapest to most expensive.

When you need to show recent messages first in a chat app.

When you want to arrange students by their scores from highest to lowest.

When you want to display events starting from the earliest date.

When you want to find the top-rated movies by sorting ratings in descending order.

Syntax

MongoDB

db.collection.find().sort({ field: 1 })  // ascending order

db.collection.find().sort({ field: -1 }) // descending order

Use 1 for ascending order (smallest to largest).

Use -1 for descending order (largest to smallest).

Examples

Sort products by price from lowest to highest.

MongoDB

db.products.find().sort({ price: 1 })

Sort messages by date from newest to oldest.

MongoDB

db.messages.find().sort({ date: -1 })

Sort students by score from highest to lowest.

MongoDB

db.students.find().sort({ score: -1 })

Sample Program

This example inserts three products with different prices. Then it finds all products sorted by price from lowest to highest.

MongoDB

use shop

// Insert sample data
 db.products.insertMany([
   { name: "Pen", price: 1.5 },
   { name: "Notebook", price: 3.0 },
   { name: "Eraser", price: 0.5 }
 ])

// Find products sorted by price ascending
 db.products.find().sort({ price: 1 }).toArray()

Important Notes

Sorting works on any field that exists in your documents.

If two documents have the same value in the sorted field, their order is undefined.

You can sort by multiple fields by adding more fields in the sort object, like { age: 1, name: -1 }.

Summary

Use sort({ field: 1 }) to order data from smallest to largest.

Use sort({ field: -1 }) to order data from largest to smallest.

Sorting helps you organize and find data quickly.

Practice

1. What does the sort({ age: 1 }) method do in MongoDB?

easy

A. Deletes documents with age less than 1

B. Sorts documents by age in descending order (largest to smallest)

C. Filters documents where age equals 1

D. Sorts documents by age in ascending order (smallest to largest)

Solution

1. Step 1: Understand the sort method parameter

   The number 1 in sort({ age: 1 }) means ascending order.

2. Step 2: Interpret the sorting effect

   Documents will be arranged from smallest age to largest age.

3. Final Answer:

   Sorts documents by age in ascending order (smallest to largest) -> Option D

4. Quick Check:

   sort({ field: 1 }) = ascending order [OK]

Hint: 1 means ascending order, -1 means descending order [OK]

Common Mistakes:

• Confusing 1 with descending order
• Thinking sort filters data
• Assuming sort deletes documents

2. Which of the following is the correct syntax to sort documents by score in descending order in MongoDB?

easy

A. db.collection.find().sort({ score: -1 })

B. db.collection.find().sort({ score: 1 })

C. db.collection.find().sort(score: -1)

D. db.collection.find().sort({ -1: score })

Solution

1. Step 1: Check the correct object syntax for sort

   The sort method requires an object with field name as key and 1 or -1 as value, inside curly braces.

2. Step 2: Identify descending order syntax

   Descending order is indicated by -1, so { score: -1 } is correct.

3. Final Answer:

   db.collection.find().sort({ score: -1 }) -> Option A

4. Quick Check:

   sort({ field: -1 }) = descending order [OK]

Hint: Use curly braces and colon: sort({ field: -1 }) [OK]

Common Mistakes:

• Missing curly braces around sort argument
• Using parentheses instead of braces
• Putting -1 as key instead of value

3. Given the documents: [{"name": "Anna", "score": 85}, {"name": "Ben", "score": 92}, {"name": "Cara", "score": 78}], what will be the order of names after running db.students.find().sort({ score: 1 })?

medium

A. ["Ben", "Anna", "Cara"]

B. ["Cara", "Ben", "Anna"]

C. ["Cara", "Anna", "Ben"]

D. ["Anna", "Cara", "Ben"]

Solution

1. Step 1: Understand ascending sort by score

   Sorting by score ascending means from smallest to largest score: 78, 85, 92.

2. Step 2: Map scores to names in order

   78 = Cara, 85 = Anna, 92 = Ben, so order is ["Cara", "Anna", "Ben"].

3. Final Answer:

   ["Cara", "Anna", "Ben"] -> Option C

4. Quick Check:

   sort({ score: 1 }) = ascending order [OK]

Hint: Ascending sort orders from smallest to largest [OK]

Common Mistakes:

• Mixing ascending with descending order
• Sorting by name instead of score
• Confusing array order in output

4. What is wrong with this MongoDB query?

db.products.find().sort({ price: 2 })

medium

A. The find() method cannot be chained with sort()

B. The sort value must be 1 or -1, not 2

C. The field name 'price' is invalid

D. Missing parentheses after sort

Solution

1. Step 1: Check valid sort values

   MongoDB sort only accepts 1 for ascending or -1 for descending, not 2.

2. Step 2: Identify the error cause

   Using 2 will cause a syntax or runtime error because it's invalid.

3. Final Answer:

   The sort value must be 1 or -1, not 2 -> Option B

4. Quick Check:

   sort values = 1 or -1 only [OK]

Hint: Sort values must be exactly 1 or -1 [OK]

Common Mistakes:

• Using numbers other than 1 or -1
• Assuming any positive number works
• Thinking sort can't chain after find()

5. You have a collection with documents containing category and price. How do you sort first by category ascending, then by price descending?

hard

A. db.collection.find().sort({ category: 1, price: -1 })

B. db.collection.find().sort({ price: -1, category: 1 })

C. db.collection.find().sort({ category: -1, price: 1 })

D. db.collection.find().sort({ category: 1 }).sort({ price: -1 })

Solution

1. Step 1: Understand multi-field sort syntax

   MongoDB sorts by fields in the order they appear in the object passed to sort().

2. Step 2: Apply ascending to category and descending to price

   Use { category: 1, price: -1 } to sort category ascending, then price descending within each category.

3. Final Answer:

   db.collection.find().sort({ category: 1, price: -1 }) -> Option A

4. Quick Check:

   Multi-field sort = object with fields in order [OK]

Hint: List fields in sort object in desired priority order [OK]

Common Mistakes:

• Reversing field order changes sort priority
• Trying to chain multiple sort() calls
• Using wrong sort values for fields