方法1:
SELECT newsid,title,classid FROM news a
WHERE (SELECT count(*) FROM news b WHERE b.classid=a.classid AND b.newsID>a.newsID )<5
ORDER BY classid asc,newsID desc
方法2:
select * from news a where newsid in(select top 5 newsid from news where classid=a.classid) order by a.newsid
总结:方法1相对方法2效率高些