SELECT id FROM HouseHold t WHERE (SELECT count(*) FROM HouseHold WHERE hh_MonitorAreaID=t.hh_MonitorAreaID AND t.id<id)<1
显示要查询的属于HouseHold表的归属于同一个MonitorAreaID的前2个id
SELECT id FROM HouseHold t WHERE (SELECT count(*) FROM HouseHold WHERE hh_MonitorAreaID=t.hh_MonitorAreaID AND t.id<id)<1
显示要查询的属于HouseHold表的归属于同一个MonitorAreaID的前2个id