MongoDB এগ리게েশন ফ্রেমওয়ার্কে গ্রুপ কুয়েরি উদাহরণ

MongoDB এগ리게শনে $group ব্যবহার করে গ্রুপ কুয়েরি

এই কাজের জন্য MongoDB এগ리게শনে $group ব্যবহার করুন।

উদাহরণ: ডকুমেন্ট সহ কালেকশন তৈরি

> db.demo639.insertOne(
...     {
...         "_id" : 1,
...         "CountryName" : "US",
...         "Info1" : {
...             "Name" : "Chris",
...             "SubjectName" : "MySQL",
...             "Marks" : 78
...         },
...         "Info2" : {
...             "Name" : "Chris",
...             "SubjectName" : "MySQL",
...             "Marks" : 78
...         }
...     }
... );
{ "acknowledged" : true, "insertedId" : 1 }
> db.demo639.insertOne(
...     {
...         "_id" : 2,
...         "CountryName" : "UK",
...         "Info1" : {
...             "Name" : "Chris",
...             "SubjectName" : "MySQL",
...             "Marks" : 79
...         },
...         "Info2" : {
...             "Name" : "Chris",
...             "SubjectName" : "MySQL",
...             "Marks" : 88
...         }
...     }
... );
{ "acknowledged" : true, "insertedId" : 2 }

সকল ডকুমেন্ট প্রদর্শন

> db.demo639.find();

আউটপুট

{ "_id" : 1, "CountryName" : "US", "Info1" : { "Name" : "Chris", "SubjectName" : "MySQL", "Marks" : 78 }, "Info2" : { "Name" : "Chris", "SubjectName" : "MySQL", "Marks" : 78 } }
{ "_id" : 2, "CountryName" : "UK", "Info1" : { "Name" : "Chris", "SubjectName" : "MySQL", "Marks" : 79 }, "Info2" : { "Name" : "Chris", "SubjectName" : "MySQL", "Marks" : 88 } }

এগ리게শন ফ্রেমওয়ার্কে $group কুয়েরি

> db.demo639.aggregate({$group : {_id : {Name1:"$Info1.Name",Name2:"$Info2.Name"},
...     Marks:{$first:"$Info2.Marks"},
...     Marks:{$sum:"$Info2.Marks"}
... }}).pretty();

ফলাফল

{ "_id" : { "Name1" : "Chris", "Name2" : "Chris" }, "Marks" : 166 }