Sort

From NoSQLzoo
Jump to: navigation, search
Top Ten Tips
Find
Insert
Create
Update
Sort
Sum and Count
Round
Join
Iterate
MapReduce

sort() is a cursor method that orders the results of a query.
The aggregation framework provides the $sort operator, and mapReduce takes sort as a parameter that is applied to the input documents.

The syntax for sort() is sort({<field>:<value>, <field>:<value>, ...}) where 1 indicates ascending and -1 indicates descending.
The order in which fields are specified dictates which fields are sorted first.

Sort all the documents in world by continent descending, then name ascending. Show only name and continent.
db.world.find({},{name:1,continent:1,_id:0}).sort({"continent": -1, "name": 1})