按时间倒排
db.somecollection.find().sort({ time : -1 });
分组统计:
#计数
db.getCollection('faceTraj').aggregate([
{
$group: {
_id: "$pid",
coun:{$sum:1}
}
},
{
$match: {"coun": {"$gte": 2}},
}
])
#求和
db.getCollection('faceTraj').aggregate([
{
$group: {
_id: "$pid",
coun:{$sum:"$relateNum"}
}
},
{
$match: {"_id": "699709739709235209"},
}
])