环境:sql server2008 R2
表结构
mag_year nvarchar
mag_month nvarchar
id mag_year mag_month title
1 2015 6 xxxxxx
2 2015 5 yyyyyy
3 2015 4 zzzzzz
4 2015 3 eeeeeeeee
5 2015 2 kkkkkkkkkkk
...................................................以此类推
假如:当前月份为2015年的2月份 我想取当前月的前4个月的数据(2014-11月至2015-2月) 该如何写Sql语句?
------解决思路----------------------
DECLARE @DATE_CUR DATETIME
SET @DATE_CUR='2015-2-1'
SELECT * FROM TA WHERE DATEDIFF(MM,mag_year+'-'+mag_month+'-01',@DATE_CUR)<=3
------解决思路----------------------
declare @dd datetime
set @dd='2015-2-1'
select * from TABLE
where (mag_year+'-'+mag_month+'-01') between DATEADD(MM,-3,@dd) and @dd