select top 5 KS_Article.Tid,KS_Article.Title,KS_Article.Hits,KS_Class.ID,KS_Class.FolderName from KS_Article,KS_Class where KS_Article.ID in (select max(KS_Article.ID) from KS_Article group by KS_Article.Tid) and KS_Article.Tid=KS_Class.ID order by KS_Article.Hits desc
这样就可以调用5个不同栏目点击数最多的1条信息