2020-02-16 标签:每个,分类,选择,10,记录,sql,语句,实现,代码,如下,select,a,content,log,id,top,cateid,order,desc

从每个分类选择10条记录 实现代码如下：select a.* from Content a where a.log_ID in (select top 10 log_ID from Content where log_CateID = a.log_CateID order by log_ID des