select语句问题！请帮忙30分钟结帖！

SELECT TOP 10 *
FROM test.article
WHERE (classid = 1) AND (DATEDIFF('d', dateandtime, date()) <= 7)
ORDER BY hits DESC, title
---------------------------------------------------------------

SELECT TOP 10 *
FROM test.article
WHERE (classid = 1) AND (DATEDIFF(d, dateandtime, getdate()) <= 7)
ORDER BY hits DESC, title

DATEDIFF的第一个参数不要加单引号

---------------------------------------------------------------

TO:orrin (orrin)
sqlserver中 (DATEDIFF(d, dateandtime, getdate()) <= 7)
access中 (DATEDIFF(d, dateandtime, date()) <= 7)