在系统变量$$ROOT上应用组累加器运算符 first，以返回对根文档的引用？
$ROOT引用当前在聚合管道阶段正在处理的根文档，即顶级文档。
让我们创建一个包含文档的集合-
> db.demo582.insertOne({FirstName:"Chris",Age:21,createDate:new ISODate("2020-01-10")});{
"acknowledged" : true, "insertedId" : ObjectId("5e91ce41fd2d90c177b5bcbd")
}
> db.demo582.insertOne({FirstName:"Chris",Age:21,createDate:new ISODate("2020-04-21")});{
"acknowledged" : true, "insertedId" : ObjectId("5e91ce4ffd2d90c177b5bcbe")
}
> db.demo582.insertOne({FirstName:"Chris",Age:22,createDate:new ISODate("2020-02-11")});{
"acknowledged" : true, "insertedId" : ObjectId("5e91ce59fd2d90c177b5bcbf")
}
> db.demo582.insertOne({FirstName:"Chris",Age:22,createDate:new ISODate("2020-01-12")});{
"acknowledged" : true, "insertedId" : ObjectId("5e91ce6efd2d90c177b5bcc0")
}在find()方法的帮助下显示集合中的所有文档-
> db.demo582.find();
这将产生以下输出-
{ "_id" : ObjectId("5e91ce41fd2d90c177b5bcbd"), "FirstName" : "Chris", "Age" : 21, "createDate" : ISODate("2020-01-10T00:00:00Z") }
{ "_id" : ObjectId("5e91ce4ffd2d90c177b5bcbe"), "FirstName" : "Chris", "Age" : 21, "createDate" : ISODate("2020-04-21T00:00:00Z") }
{ "_id" : ObjectId("5e91ce59fd2d90c177b5bcbf"), "FirstName" : "Chris", "Age" : 22, "createDate" : ISODate("2020-02-11T00:00:00Z") }
{ "_id" : ObjectId("5e91ce6efd2d90c177b5bcc0"), "FirstName" : "Chris", "Age" : 22, "createDate" : ISODate("2020-01-12T00:00:00Z") }以下是应用GroupAccumulator运算符的查询-
> db.demo582.aggregate([
... {
... "$group": {
... "_id": "$FirstName",
... "MaximumDate": {
... "$max": "$createDate"
... },
... "count": {
... "$sum": 1
... },
... "details": {
... "$first": "$$ROOT"
... }
... }
... },
... {
... "$project": {
... "MaximumDate": 1,
... "count": 1,
... "details": {
... "_id": "$_id",
... "FirstName": "$details.FirstName",
... "Age" : "$details.Age",
... }
... }
... }
... ])这将产生以下输出-
{ "_id" : "Chris", "MaximumDate" : ISODate("2020-04-21T00:00:00Z"), "count" : 4, "details" :
{ "_id" : "Chris", "FirstName" : "Chris", "Age" : 21 }
}热门推荐
10 公司过年祝福语简短优美
11 感恩老婆礼物祝福语简短
12 古风考试祝福语 唯美简短
13 小托班祝福语简短
14 企业老板文案祝福语简短
15 新年祝福语大全牛年 简短
16 拜年年祝福语大全简短
17 送给妈妈新年祝福语简短
18 老师给家长祝福语简短