In mongodb how to get the highest count of salary

Question

In Mongo db I have some sample data as follows:

Object 1

{
 'id': 1,
 'name': 'ram',
 'age': 25,
 'group': 'developer',
 'salary': 30000
}

Object 2

{
 'id': 2,
 'name': 'sai',
 'age': 27,
 'group': 'developer',
 'salary': 45000
}

This is some sample data in the mongodb and I have so many objects all related to employee details.

From this data how to get the 1st or 2nd or 3rd highest salary and the details. So query should be like if i want 3rd highest salary it has to give me the all the details of matching document even if the salary is changed. The query should not need to be changed if the salary is increased.

Akrion · Answer 1 · 2018-08-08T15:32:27.317

0

I just put limit there just in case ... not sure how big is your collection etc.

With just find:

db.getCollection('<ColName>').find({}).sort({ salary: -1 }).limit(3)

With aggregate:

db.collection.aggregate([
  { $sort: { "salary": -1} },
  { $skip : 2 },  // Skip the first 2 and get the 3rd
  { $limit: 1}    // Only get the 3rd
])

You can test/see the result here

edited Aug 08 '18 at 15:32

answered Aug 08 '18 at 05:55

Akrion

18,117
1
34
54

The sort will give the data from highest to lowest or opposite .But is there a query were we can only get the details of the 3rd highest or 2nd highest.(But this query was helpfull) – Anjansai Aug 08 '18 at 10:45
Use `$skip` and `$limit` to get only the 3rd or 2nd. Updated the answer. – Akrion Aug 08 '18 at 15:32
@Anjansai did that help? – Akrion Aug 08 '18 at 19:49

score 0 · Answer 2 · edited Aug 08 '18 at 16:31

0

Please try this:

db.collection.aggregate([{
    $project: {
      max: {
        $max: "$salary"
      },
      salary: 1
    }
  }, {
    $sort: {
      "salary": -1
    }
  },
  {
    $limit: 3
  }
])

This always works for me.

edited Aug 08 '18 at 16:31

Patrick Mevzek

10,995
16
38
54

answered Aug 08 '18 at 06:00

Raj Jaril

376
1
16

score 0 · Answer 3 · edited Aug 08 '18 at 06:29

0

Here is how you can achieve that:

db.getCollection('tablename').find({}).sort({salary:-1}).toArray();

Your first item of the array will have the max salary while the last will have the min salary

edited Aug 08 '18 at 06:29

Nico Haase

11,420
35
43
69

answered Aug 08 '18 at 06:00

Shantanu Madane

617
5
14

score 0 · Answer 4 · answered Sep 07 '19 at 15:35

0

Just skip n-1 records if want nth highest salary record using following query.

db.getCollection('<ColName>').find({}).sort({ salary: -1 }).skip(n-1).limit(1)

answered Sep 07 '19 at 15:35

Devender Chaudhary

1
1
2

In mongodb how to get the highest count of salary

4 Answers4