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
转载于:https://www.cnblogs.com/Iyce/archive/2013/01/09/2852921.html