db.units.aggregate( [
{
$group: {
_id: {
unitNumber: "$unitNumber"
},
total: { $sum: 1 }
}
},
{ $match: { total: { $gt: 1 } } }
] )
相当于mysql
select unitNumber, count(unitNumber)
from units
group by unitNumber
having count(unitNumber) > 1
mongodb常用语句
//删除数组中的某一列
db.units.updateMany( {}, {$unset: {"userList.$[].aliasName":1}} );
//删除某一列
db.units.updateMany({"userList.userId":"617a4a0e6d4d37445db764d5"},{$unset:{"userList":{"aliasName":""}}},false,true);
//加索引
db.cp_report_query_history.createIndex( { "$**" : 1 } )
//清空表
db.cp_user_units_history_test.deleteMany({});
//去重
db.cp_report_query_history.aggregate( [
{
$group: {
_id: {
userId: "$brand"
},
total: { $sum: 1 }
}
},
{ $match: { total: { $gt: 1 } } }
] )
//分组
db.units.aggregate(
[
{
"$group": {
"_id": {
"brand": "$brand"
}
}
},
{
"$project": {
"brand": "$_id.brand"
}
},
{
"$sort": {
"brand": 1
}
}
]
);
//按日期查询
db.interface_log.find({type:'SMS', "createDate" : {"$gte" : ISODate("2021-12-01T00:00:00Z")}});