〈 ％
sqlnow = Left(now()-7,10)
sql1 = "select top 14 * from forum where posttime>"& sqlnow &" order by Views desc"
％〉

为什么这句读出的贴子是本周发的所有贴子，而不是提取表的前14个记录？

by Views desc

by id desc

能不能说一下原理啊？谢谢