SQLserver查询最近三个月的数据,语句该怎么写sqlserver

SQLserver查询最近三个月的数据,语句该怎么写sqlserver

很好写啊
select field1,field2 from tablename where datediff(dd,DTime,GETDATE())<=90

有日期标识字段吗,有的话直接用where datediff ( month , 时间字段 , getdate ()) = 3进行筛选

Select *From BS_CashCoupon Where DATEADD(MONTH, -3, GETDATE()) < ExpireTime