sort method ascending and descending in MongoDB - Cheat Sheet & Quick Revision

Recall & Review

beginner

What does the sort() method do in MongoDB?

The sort() method orders the documents in a query result by one or more fields, either ascending or descending.

beginner

How do you specify ascending order in MongoDB's sort() method?

Use 1 as the value for the field in the sort() method to sort ascending (smallest to largest).

beginner

How do you specify descending order in MongoDB's sort() method?

Use -1 as the value for the field in the sort() method to sort descending (largest to smallest).

beginner

Example: How to sort documents by age ascending in MongoDB?

Use db.collection.find().sort({ age: 1 }) to get documents sorted by the age field from smallest to largest.

beginner

Example: How to sort documents by age descending in MongoDB?

Use db.collection.find().sort({ age: -1 }) to get documents sorted by the age field from largest to smallest.

What value do you use in sort() to sort a field in ascending order?

A -1

B true

C 0

D 1

Ascending order is specified by 1 in MongoDB's sort method.

What does db.collection.find().sort({ score: -1 }) do?

A Sorts documents by score descending

B Sorts documents by score ascending

C Filters documents with score -1

D Sorts documents randomly

Using -1 sorts the documents by the score field in descending order.

Which of these is the correct way to sort by two fields, name ascending and age descending?

A sort({ name: 1, age: -1 })

B sort({ name: -1, age: 1 })

C sort({ name: 0, age: 0 })

D sort({ name: true, age: false })

You specify each field with 1 for ascending and -1 for descending.

If you want the smallest values first, which sort value do you use?

A -1

B 1

C 0

D null

1 means ascending order, which puts smallest values first.

What happens if you omit the sort() method in a MongoDB query?

A Documents are sorted ascending by default

B Documents are sorted descending by default

C Documents are returned in natural order (insertion order)

D Query will fail

Without sort(), MongoDB returns documents in natural order, usually insertion order.

Explain how to use the sort() method in MongoDB to order query results.

Think about how you tell MongoDB which field and direction to sort.

Describe the difference between ascending and descending sort orders in MongoDB and how to specify each.

Focus on the numeric values used in the sort method.