Sort Records
~10 mins
Prerequisite: Sample Data
db.users.insertMany([{name:"Naresh", email:"nareshkumarh@live.com", password:"pass123", role:"ADMIN"},{name:"Suresh", email:"suresh@gmail.com", password:"pass123", role:"USER"},
{name:"Prabu", email:"prabhu@gmail.com", password:"pass123", role:"USER"}]);
Reference
Task 1.1: Sort Records ( name ascending )
db.users.find().sort({name:1});
{ "_id" : ObjectId("5fc074d548cb2dbe817558eb"), "name" : "Naresh", "email" : "nareshkumarh@live.com", "password" : "newpassword", "role" : "ADMIN", "active" : 1 }
{ "_id" : ObjectId("5fc074d548cb2dbe817558ed"), "name" : "Prabu", "email" : "prabhu@gmail.com", "password" : "pass123", "role" : "USER", "active" : 1 }
{ "_id" : ObjectId("5fc074d548cb2dbe817558ec"), "name" : "Suresh", "email" : "suresh@gmail.com", "password" : "pass123", "role" : "USER", "active" : 1 }
Task 2: Sort Records ( name descending )
db.users.find().sort({name:-1});
{ "_id" : ObjectId("5fc074d548cb2dbe817558ec"), "name" : "Suresh", "email" : "suresh@gmail.com", "password" : "pass123", "role" : "USER", "active" : 1 }
{ "_id" : ObjectId("5fc074d548cb2dbe817558ed"), "name" : "Prabu", "email" : "prabhu@gmail.com", "password" : "pass123", "role" : "USER", "active" : 1 }
{ "_id" : ObjectId("5fc074d548cb2dbe817558eb"), "name" : "Naresh", "email" : "nareshkumarh@live.com", "password" : "newpassword", "role" : "ADMIN", "active" : 1 }