在这个基础上查询ID=123的SQL语句应该怎么写 ---------------------------------------------- 这个还不是很明白你意思select * from tablename where dt between '2006-7-23 14:09:38' and dateadd(s,30,'2006-7-23 14:09:38') and id=123?? 还是 select ..... from (select * from tablename where dt between '2006-7-23 14:09:38' and dateadd(s,30,'2006-7-23 14:09:38'))t where t.id=123??
select * from aa where gpstime between dateadd(s,-30,'2006-7-23 14:10:38') and dateadd(s,30,'2006-7-23 14:10:38') and ID=123select * from (select * from aa where gpstime between dateadd(s,-30,'2006-7-23 14:10:38') and dateadd(s,30,'2006-7-23 14:10:38'))t where t.ID=123好像都一样啊,是不是第二种方法能好一点?
where dt between '2006-7-23 14:09:38' and dateadd(s,30,'2006-7-23 14:09:38')
是不是在'2006-7-23 14:09:38'前30秒可以写成dateadd(s,-30,'2006-7-23 14:09:38')
还是新手,请大家多帮忙
----------------------------------------------
这个还不是很明白你意思select * from tablename
where dt between '2006-7-23 14:09:38' and dateadd(s,30,'2006-7-23 14:09:38')
and id=123??
还是
select ..... from (select * from tablename
where dt between '2006-7-23 14:09:38' and dateadd(s,30,'2006-7-23 14:09:38'))t
where t.id=123??
where gpstime between dateadd(s,-30,'2006-7-23 14:10:38') and dateadd(s,30,'2006-7-23 14:10:38') and ID=123select * from (select * from aa
where gpstime between dateadd(s,-30,'2006-7-23 14:10:38') and dateadd(s,30,'2006-7-23 14:10:38'))t
where t.ID=123好像都一样啊,是不是第二种方法能好一点?