SyntaxFix
Write A Post
Hire A Developer
Questions
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;