我有一个名为ExternalHits的SQL网站点击表,跟踪URLx作为URL和访问页面的日期作为Datex。我每周运行此查询以获取前一周的总点击数,并且每周都必须手动更改“between”日期。是否有一种方法可以更改我的查询,使“between”日期变成类似于TODAY AND TODAY-7的东西?我只想不必每周手动更改日期。
SELECT URLX, COUNT(URLx) AS Count
FROM ExternalHits
WHERE datex BETWEEN '02/27/2017' AND '03/05/2017'
GROUP BY URLx
ORDER BY Count DESC;
BETWEEN CONVERT(date, GETDATE()) AND DATEADD(DD, -7, CONVERT(date, GETDATE()))
。您的标签存在冲突。这是MySQL还是Microsoft SQL Server? - Cᴏʀʏ