如何查询三个月之内的数据啊

[copytables]

表中有个samptime字段smalldatetime类型，请问该如何查询当前时间的三个月之内的数据呢？

[wzy_love_sly]

select * from tbname
where datediff(mm,dt,getdate())<=3

[hlq8210]

select * from tbname
where datediff(month,dt,getdate())<=3

[dawugui]

表中有个samptime字段smalldatetime类型，请问该如何查询当前时间的三个月之内的数据呢？

--按月.
select * from tb where datediff(mm,samptime,getdate()) <= 3

--按天(假设为90)
select * from tb where datediff(day,samptime,getdate()) <= 90

[-狙击手-]

select * from tbname
where datediff(mm,dt,getdate()) between 0 and 3

[山之魂2]

select * from tbname
where datediff(dd,dt,getdate())<=90

[华芸智森]

表中有个samptime字段smalldatetime类型，请问该如何查询当前时间的三个月之内的数据呢？
========================================

DECLARE @DTE_DATE DATETIME
SELECT @DTE_DATE=DATEDIFF(Month,-3,MAX(samptime)) FROM TABLE1
SELECT * FROM TABLE1 WHERE samptime>=@DTE_DATE