select top x * from ...order by xxx desc
按xxx降序顺序取出最上面的x条记录
sql="select top 4 * from SW_article where Passed=1 and IsGood=1 and minipic<>'' and stype<>'1' and UpdateTime>"&sysdate&"-7 order by Hits desc, ArticleID desc"
按Hits(点击率)和ArticleID(自动编号,即最后更新)降序排列【即选出最后更新里边点击率最高的4个文章】
且要符合Passed=1 (1审核0未审核)and IsGood=1 (1推荐0为推荐)and minipic<>'' and stype<>'1' and UpdateTime>"&sysdate&"-7(更新时间大于以当天为准前七天的时间)