请教一个sql语句

[sinat_40026833]

查询时选择一个年作为条件 会查出这一年以及前一年两年12个月的数据 求一些实例

[二月十六]

--测试数据
if not object_id(N'Tempdb..#T') is null
	drop table #T
Go
Create table #T([testdate] Date)
Insert #T
select '2017-08-01' union all
select '2016-08-01' union all
select '2016-01-01' union all
select '2015-08-01' union all
select '2014-01-01'        
Go
--测试数据结束
DECLARE @date DATE = '2017-01-01'
Select * from #T WHERE DATEDIFF(YEAR,testdate,@date)<=1

[繁花尽流年]

LZ意思是2年该节点的同期对比，还是取以当前节点回滚的滚动1年？

[sinat_40026833]

引用 1 楼 sinat_28984567 的回复:

--测试数据
if not object_id(N'Tempdb..#T') is null
	drop table #T
Go
Create table #T([testdate] Date)
Insert #T
select '2017-08-01' union all
select '2016-08-01' union all
select '2016-01-01' union all
select '2015-08-01' union all
select '2014-01-01'        
Go
--测试数据结束
DECLARE @date DATE = '2017-01-01'
Select * from #T WHERE DATEDIFF(YEAR,testdate,@date)<=1

谢谢