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

原文地址:https://www.cnblogs.com/Iyce/p/2852921.html