参照这篇文章http://www.cnblogs.com/JulyZhang/archive/2011/02/12/1952213.html,拿出每个分类中的前几记录,写成的mysql如下:
select a.id,name,type from adpos a where 3 > (select count(*) from tablename where type = a.type and id < a.id ) order by a.type,a.id
mysql居然不会支持top ,比如select top 3 id from table order by type,id,就不行。