sql - 从年/月而不是日期字段中选择滚动日期范围

Question

我需要从包含以下字段的表中选择过去 12 个月的滚动需求:

Item,
Year,
Month,
Demand Qty

我尝试了以下方法:

Select Item, [Year], [Month],[Demand QTY]
FROM [table1]
Where   
(
    [Year] >= Year(getdate())-'1'
and [Month] >= Month(getdate())
)
and
(
    [Year] < year(getdate())+'1'
and [Month] <= month(getdate())
)

但我只获得了去年和本月今年的记录。

Item    Year    Month   Demand Qty
CD051   2011    3       8800
CD051   2012    3       0

我还是个菜鸟，所以我可能会犯明显的错误。有人可以帮我吗？

Answer 1

尝试:

Select Item, [Year], [Month],[Demand QTY] 
FROM [table1] 
Where ( [Year] = Year(getdate())-'1' and [Month] >= Month(getdate()) ) or 
      ( [Year] = year(getdate()) and [Month] <= month(getdate()) )