sql语句查询同一类别的前几条数据

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

posted on 2013-01-09 14:34  酒歌  阅读(381)  评论(0编辑  收藏  举报