ต้องการเลือกข้อมูลที่มากที่สุด ใน account นั้นๆ ออกมาแสดงเพียงแค่1 (JavaScript)

.find({}).sort("account_name":-1).limit(1)

select fm.* from tablename fm, (
  select max(m.id) x 
  from (select user_id, max(amt) mx from tablename group by user_id) as t 
  left join tablename as m on m.user_id = t.user_id and t.mx=m.amt
  group by user_id) tx
where fm.id=tx.x

var options = {
    "limit": 20,
    "skip": 10,
    "sort": "title"
}

collection.find({}, options).toArray(...);

{
  "sort": [['field1','asc'], ['field2','desc']]
}

db.employees.find({})

db.employees.aggregate([{
    $group: {
        _id: "$employeeId",
        "dups": {
            "$push": "$_id"
        },
        count: {
            $sum: 1
        }
    }
}, {
    $match: {
        count: {
            "$gt": 1
        }
    }
}, {
    $sort: {
        count: -1
    }
}]);

db.employees.insertOne({employeeId: 1, employeeName: "Anand"})
db.employees.insertOne({employeeId: 2, employeeName: "Wayne"})
db.employees.insertOne({employeeId: 3, employeeName: "Clark"})
db.employees.insertOne({employeeId: 2, employeeName: "Juan"})
db.employees.insertOne({employeeId: 3, employeeName: "Naval"})