标准sql 查前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