sql server有下列語句:
// 查找名字性別唯一的學(xué)生
select distinct name,sex from student
// 轉(zhuǎn)換成MongoDB的話，我怎么把這種組合列去重,MongoDB好像只支持單個(gè)field的去重
db.student.distinct("name"); // 只支持一個(gè)field
db.student.distinct("name","sex"); // 錯(cuò)誤的，不支持多個(gè)field的組合去重
有沒有大神解決過類似問題，求指導(dǎo).................
3
0
0
擁有18年軟件開發(fā)和IT教學(xué)經(jīng)驗(yàn)。曾任多家上市公司技術(shù)總監(jiān)、架構(gòu)師、項(xiàng)目經(jīng)理、高級(jí)軟件工程師等職務(wù)。 網(wǎng)絡(luò)人氣名人講師，...
> db.test.find()
{ "_id" : ObjectId("55de6075024f45b4947d4cc3"), "name" : "zhangsan", "sex" : "FEMALE", "age" : 12 }
{ "_id" : ObjectId("55de6076024f45b4947d4cc4"), "name" : "zhangsan", "sex" : "MALE", "age" : 16 }
{ "_id" : ObjectId("55de6076024f45b4947d4cc5"), "name" : "lisi", "sex" : "FEMALE", "age" : 20 }
{ "_id" : ObjectId("55de6076024f45b4947d4cc6"), "name" : "zhangsan", "sex" : "FEMALE", "age" : 25 }
{ "_id" : ObjectId("55de6076024f45b4947d4cc7"), "name" : "lisi", "sex" : "FEMALE", "age" : 36 }
{ "_id" : ObjectId("55de6077024f45b4947d4cc8"), "name" : "zhangsan", "sex" : "FEMALE", "age" : 28 }
> db.test.aggregate([
... { $group: { _id: { name: "$name", sex: "$sex" } } }
... ])
{ "_id" : { "name" : "lisi", "sex" : "FEMALE" } }
{ "_id" : { "name" : "zhangsan", "sex" : "MALE" } }
{ "_id" : { "name" : "zhangsan", "sex" : "FEMALE" } }
> db.test.distinct("name");
[ "zhangsan", "lisi" ]
> db.test.distinct("name","sex");
[ "zhangsan", "lisi" ]
> db.test.distinct("name","sex","age");
[ "zhangsan", "lisi" ]樓上的方法是正確的，mongoDB確實(shí)不支持組合去重，mongo官網(wǎng)提供的示例也只是對(duì)單個(gè)字段去重。
官網(wǎng)示例： http://docs.mongodb.org/manual/core/single-purpose-aggregation/
