SQL查询，其中日期=今天减去7天

Question

我的网站的命中SQL表格名为ExternalHits。我将URL跟踪为URLx，将访问页面的日期跟踪为Datex。我每周运行一次此查询，以获取前一周的总点击数，并且每周我都必须手动更改“之间”的日期。有什么方法可以更改查询，以使“之间”的日期类似于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;

Answer 1

declare @lastweek datetime
declare @now datetime
set @now = getdate()
set @lastweek = dateadd(day,-7,@now)

SELECT URLX, COUNT(URLx) AS Count
FROM ExternalHits
WHERE datex BETWEEN @lastweek AND @now
GROUP BY URLx
ORDER BY Count DESC;