//根据一手楼盘id(resblockOneId)分组,获取每组内房价最高(totalprBegin)的一手房源id(houseOne1Id)db.mhouseonedetail.group({'key':{'resblockOneId':1},'$reduce':function(doc,prev){ var junjia = (doc.totalprBegin+doc.totalprEnd)/2 ; if(junjia > prev.totalprBegin) { prev.totalprBegin= junjia; prev.resblockOneId =doc.resblockOneId ; prev.houseOne1Id = doc.houseOneId; }}, 'initial':{'totalprBegin':1,'resblockOneId':'0','houseOne1Id':'0'}})
-----------------等同于SQL---------------------
select *
from salesmgmt.t_hm_house
where pkid in
(
select min(pkid)
from salesmgmt.t_hm_house house1,
(select RESBLOCK_ID resblockId, max(PROPERTY_FEE) maxfee
from salesmgmt.t_hm_house
group by RESBLOCK_ID
) house2
where house1.resblock_id = house2.resblockId
and house1.PROPERTY_FEE = house2.maxfee
group by house1.resblock_id, house2.maxfee
)