例如在mysql或oracle中写分组sql
select name,sex,sum(studentCount)
from class
group by name,sex
这种sql在mongoDB怎么写,而且是写在java中的
SQL的对应关系
http://docs.mongodb.org/manual/reference/sql-aggregation-comparison/
java的参考
http://stackoverflow.com/questions/14802289/mongodb-java-group-count-function
db.class.group(
{
key:{'name':true,'sex':true},
initial:{num1:0},
$reduce:function(doc,prev){
prev.num1++
}
}
);
参考资料
http://blog.csdn.net/zy_281870667/article/details/50242441