你可以用order by hits　desc实现．例：

select top 10 id,title,adddate from ks_article where verific=1 order by hits desc