Select * from table1 where datediff(day,time,getdate())>=365
解决方案 »
- 连接数据库时数据库名称问题
- 毫无头绪的sqlserver分类排序汇总的问题!!!
- count(null)问题探讨
- 数据库事务问题
- 怎么用触发器监视一个表是所有字段是否要更新
- log explorer 对主从表还原时先还原从表导致违反关系不能还原
- 如何枚举出局域网内的sqlsever数据库服务器名?
- 二个数据库定时同步问题,请教高手帮助~~~~~~~~~~~~~~~~~~~~~~~~
- 比较急的问题,金蝶的数据库问题
- 请教sql语句:如何一条sql语句取出分组数据中值最大的那列数据
- 一条SQL语句问题 不知道怎么写 高手赐教
- 在 Sql Server 2000 中返原 Sql Server 6.0 下的备份文件.dat
where [time] between '2004-1-1' and '2004-12-1'
and [time]<=dateadd(year,-1,getdate())
from table1
where time between '2004-1-1' and '2004-12-1'
and datediff(day,time,getdate())>=365
select * from table where datediff(day,getdate(),time)>=365 and between '2004-1-1' and '2004-12-1'
select * from table1 where time between '2004-01-01' and '2004-12-01'
and time>=datediff(day,time,getdate())方法2:
select * from table1 where time between '2004-01-01' and '2004-12-01'
and time>=dateadd(year,-1,getdate())
select * from table1 where time between '2004-01-01' and '2004-12-01'
and datediff(day,time,getdate())>=365