如何在SQL Server中选择不同年份之间的周数

Question

我需要获取2018年的数据和周数，但我在一个数据库中有2017年的数据和2018年的数据和周数。

我试试这个：

DECLARE @sub_week AS INT 
SET @sub_week='01'
SELECT 
    DATEPART(WEEK, DATEADD(DAY, -1, Day)) Week, day, RTP
FROM 
    [Daily Beyond]
WHERE 
    DATEPART(WEEK, DATEADD(DAY, -1, Day)) = @sub_week

但结果我得到数据 2017.

如何在 2018 年获取数据？

Answer 1

declare @sub_week as int;
set @sub_week='01';
SELECT datepart(WEEK,DATEADD(year,1,datecolumn)) AS Wk, 
       datepart(day,DATEADD(year,1,datecolumn)) as day,
       dateNAME(w,DATEADD(year,1,datecolumn)) as Weekday,
       RTP
  FROM [Daily Beyond]
      WHERE datepart(WEEK,DATEADD(year,1,datecolumn))= @sub_week;