mysql - 上周同比数据

Question

我目前正在编写一个查询，它将提供上周的数据(假设“销售”)和去年同一周的数据。这是我上周必须获得的数据，它工作正常:

Set DATEFIRST 1 
Select DATEPArt(dd, DateAdded) AS 'Day of the Month', 
       count(*)AS 'Number of Users'
from TABLE1
Where DateAdded >= dateadd(day, -(datepart(dw, getdate()) + 6), CONVERT(date,getdate()))
  AND DateAdded <  dateadd(day, 1-datepart(dw, getdate()), CONVERT(date,getdate())) 
Group by DATEPArt(dd, DateAdded)
Order by 'Day of the Month'   

现在我想添加另一列，该列将为我提供去年同一周的数据。这就是我的想法:

Set DATEFIRST 1 
Select DATEPArt(dd, DateAdded) AS 'Day of the Month', 
       count(*)AS 'Number of Users'
from TABLE1
Where DateAdded >= DATEADD(yy,DATEDIFF(yy,0,GETDATE())-1,0)
  AND DateAdded < DATEADD(yy,DATEDIFF(yy,0,GETDATE())+1,0)
  AND DateAdded >= dateadd(day, -(datepart(dw, getdate()) + 6), CONVERT(date,getdate()))
  AND DateAdded <  dateadd(day, 1-datepart(dw, getdate()), CONVERT(date,getdate()))
Group by DATEPArt(dd, DateAdded), DateAdded
Order by 'Day of the Month'   

问题是我仍然得到上周的数字(今年，我需要去年的数字)。这让我相信错误一定出现在某个地方:

DateAdded >= DATEADD(yy,DATEDIFF(yy,0,GETDATE())-1,0)
AND DateAdded < DATEADD(yy,DATEDIFF(yy,0,GETDATE())+1,0)

感谢大家的帮助!!

Answer 1

您正在寻找 OR 条件

WHERE (DateAdded >= DATEADD(yy,DATEDIFF(yy,0,GETDATE())-1,0)
  AND DateAdded < DATEADD(yy,DATEDIFF(yy,0,GETDATE())+1,0))

OR (DateAdded >= dateadd(day, -(datepart(dw, getdate()) + 6), CONVERT(date,getdate()))
  AND DateAdded <  dateadd(day, 1-datepart(dw, getdate()), CONVERT(date,getdate())))