标准
sql select a.* from table as a,table as b where a.id>=b.id group by a.id having count(*)<=10
select * from table a where (select count(*) from table b where a.id>b.id)<10
标准
sql select a.* from table as a,table as b where a.id>=b.id group by a.id having count(*)<=10
select * from table a where (select count(*) from table b where a.id>b.id)<10