mongodb-聚合查询

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")}});