Display the last two values from field with MongoDB



Let us first create a collection with documents −

> db.numberOfValuesDemo.insertOne({"Values":[100,200,300,900,1000,98]}); {    "acknowledged" : true,    "insertedId" : ObjectId("5cefb736ef71edecf6a1f6ab") }

Display all documents from a collection with the help of find() method −

> db.numberOfValuesDemo.find().pretty();

Output

{    "_id" : ObjectId("5cefb736ef71edecf6a1f6ab"),    "Values" : [       100,       200,       300,       900,       1000,       98    ] }

Following is the query to get the last two values.

Here, we have used -ve sign under $slice −

> db.numberOfValuesDemo.find({},{ "Values": { "$slice": -2 } } );

Output

{ "_id" : ObjectId("5cefb736ef71edecf6a1f6ab"), "Values" : [ 1000, 98 ] }
Updated on: 2019-07-30T22:30:26+05:30

101 Views

Kickstart Your Career

Get certified by completing the course

Get Started
Advertisements