#示例
将sysTerminalFile表按fname分组,查找出重复的fname
use dba;
rs=db.sysTerminalFile.aggregate([
{$group:{_id:"$fname",count:{$sum:1} } },{$match:{count:{$gt:1}}}
])
while(rs.hasNext()) {
printjson(rs.next());
}
#示例
将sysTerminalFile表按fname分组,查找出重复的fname
use dba;
rs=db.sysTerminalFile.aggregate([
{$group:{_id:"$fname",count:{$sum:1} } }}