Select * from 表 a where NewsID in(Select Top 5 NewsID from 表 b where b.N_Type=a.N_Type Order by NewsID desc)
select * from FROM X_News a where (select count(1) from FROM X_News b where a.NewsID<=b.NewsID and a.NewsType=b.NewsType) <=5 order by a.NewsType,a.NewsID DESC
select NewsID,NewsTitle,NewsType from X_News tem where NewsID in (select top 5 NewsID from x_News where NewsType=tem.NewsType order by NewsID DESC)
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货