select top 10 * from PE_Article where ArticleID in (select max(ArticleID) from PE_Article where ClassID=1 group by Title) order by UpdateTime desc,ArticleID desc
www.diandiba.com