Question

sql 一个记录编号有一个开始时间段和结束时间段，如何取出开始时间与结束时间的之间的一条记录

如下效果 000003 2012-07-05 2012-09-20 1

Answer 1

请参考下列SQL语句：

select top 1 * from tblName 
where addtime between '2012-07-05' and '2012-09-30' 
and state=1 order by addtime DESC;

Answer 2

select name,max(a.addtime),max(b.addtime) from table a left join
(select name,max(addtime) as addtime from table group by name)b
on a.name=b.name
where a.addtime<>b.addtime
group by a.name

Answer 3

select * from tableName where name='000003' addtime>'2012-07-05' and addtime<'2012-09-20' limit 1 ;
你自己修改下表名tableName就可以用了

Answer 4

select top 1 * from table where min(time)<time<max(time)