Select * From rm_article As A Where
(Select Count(0) From rm_article Where cid=A.cid And aid >= A.aid group by cid) <11
Order By A.cid,A.aid desc
查询每分类前10条记录
最新推荐文章于 2020-12-28 20:36:34 发布
Select * From rm_article As A Where
(Select Count(0) From rm_article Where cid=A.cid And aid >= A.aid group by cid) <11
Order By A.cid,A.aid desc