select top 5 * from news where newsid in (select top 5 max(newsid) as newsid from news group by classid) order by addtime desc
每个栏目取不同的一条信息
最新推荐文章于 2024-01-11 17:10:59 发布
select top 5 * from news where newsid in (select top 5 max(newsid) as newsid from news group by classid) order by addtime desc