mongodb中distinct查询

找出指定集合中指定键的所有不同的值

> db.c1.find({},{_id:0})
{ "name" : "John", "age" : 20, "sex" : "M" }
{ "name" : "Tom", "age" : 21, "sex" : "F" }
{ "name" : "Davi", "age" : 20, "sex" : "F" }
{ "name" : "Lily", "age" : 22, "sex" : "M" }
{ "name" : "Lucy", "age" : 22, "sex" : "M" }
{ "name" : "Lucy", "age" : 22, "sex" : "M", "hobby" : [ "music", "sport" ] }
{ "name" : "Smith", "age" : 21, "sex" : "F", "hobby" : null }
{ "name" : "Sam", "age" : 20, "sex" : "F", "hobby" : [ "swimming" ] }
> db.runCommand({distinct:"c1",key:"name"})
{
        "values" : [
                "John",
                "Tom",
                "Davi",
                "Lily",
                "Lucy",
                "Smith",
                "Sam"
        ],
        "stats" : {
                "n" : 8,
                "nscanned" : 0,
                "nscannedObjects" : 8,
                "timems" : 134,
                "planSummary" : "COLLSCAN"
        },
        "ok" : 1
}