如何实现SQL查询：查找从三天前到今天的所有记录?select from table1 where ModifiedTime...?

上面这些回答真是搞笑```5-12``如果你们明天看到这个题目,那就是5-13了?
正确的sql 是

select * from table1 ModifiedTime<getdate((DAY))
where datediff(d,ModifiedTime,getdate())>3

SELECT * FROM TABLE WHERE DATE>20070506 ORDER BY DESC

按时间查询
今天是5.15
你就查询在大于5.12那天后的就行

select from table1 where ModifiedTime<= and ModifiedTime>=

select * from table1 where ModifiedTime>'2007-05-12'

select * from table1 where (day(getdate())-day(modifiedtime)>3 and
year(getdate())=year(modifiedtime) and month(getdate())=month(modifiedtime))
or (
year(getdate())=year(modifiedtime) and month(getdate())-month(modifiedtime)>0)
or
(
year(getdate())-year(modifiedtime)>0 )