一些MongoDB示例向您展示如何执行分组,计数和排序查询。
1.测试数据
一个whois_range
集合,包含许多记录。
> db.whois_range.find();
{
"_id" : 1,
"country" : "us",
"source" : "ARIN",
"status" : "NEW",
"createdDate" : ISODate("2016-05-03T08:52:32.434Z")
},
{
"_id" : 2,
"country" : "us",
"source" : "ARIN",
"status" : "NEW",
"createdDate" : ISODate("2016-05-03T09:52:32.434Z")
},
{
"_id" : 3,
"country" : "cn",
"source" : "APNIC",
"status" : "NEW",
"createdDate" : ISODate("2016-05-03T10:52:32.434Z")
},
{
"_id" : 4,
"country" : "eu",
"source" : "RIPE",
"status" : "NEW",
"createdDate" : ISODate("2016-05-03T10:52:32.434Z")
},
{...}
PS“源” = RIPE,AFRINIC,KRNIC,LACNIC,APNIC,JPNIC和ARIN
2.组和计数示例
按“来源”分组,然后计算“来源”总数。