select top 10 ID,Tid,Title,Hits from KS_Article where Adddate>=date() order by Hits Desc

试试这个。