mongdb 按条件查询,并按指定字段分组,查数量,降序排列
db.t_entity_staff.aggregate([
{
$match:{"basic_attrs.orgCode":{ '$in' :["X000009471","X000009478","X1","X2","X3","X4","X5","X6","X7","X8","X9","X10"]},
"basic_attrs.status": 1}
},
{
$group: {
_id : '$basic_attrs.orgCode',
'count' :{'$sum':1},
}
},
{
$sort: {'count':-1},
},
{
$limit: 10,
},
])