MongoDB:如何从收款中找到第n个最高薪水 [英] MongoDB: How to find nth highest salary from collection

问题描述

我需要从Employees集合中找到mongodb中第n高的薪水. 如果有人能想到在mongodb中应用联接的想法，那也将非常有帮助.

I need to find the nth highest salary in a mongodb from Employees collection. also would be really helpful if someone could gimme an idea of applying joins in mongodb.

推荐答案

这应该有效

db.Employees.find({}).sort({"Emp salary":-1}).limit(1) //for first highest salary

db.Employees.find({}).sort({"Emp salary":-1}).skip(1).limit(1) // for second highest salary

类似地，您可以执行db.Employees.find({}).sort({"Emp salary":-1}).skip(nthVarible - 1).limit(1).

Similarly you can do db.Employees.find({}).sort({"Emp salary":-1}).skip(nthVarible - 1).limit(1).

这篇关于MongoDB:如何从收款中找到第n个最高薪水的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！