现有表 Term
结构如下
time1 time2 idterm
2009-2-15 2009-6-30 11
2009-9-10 2010-1-15 12
如果输入 2009-4-25 则应该取出idterm 11
如果输入 2009-12-5 则应该取出idterm 12
这个SQL该怎么写？
分少请见谅
SQL code:
select idterm from tb
where time1<=输入日期 and time2>=输入日期
SQL code:
declare @time datetime
set @time ='2009-4-25'
select top 1 * from term where time1<=@time and time2 >=@time
SQL code:
declare @time1 datetime,@time2 datetime
set @time1=..
set @time2=..
select idterm from tb where time between @time1 and @time2
case...when....then..
select idterm from tb
where time1 <=time2 and time2>=time1
引用
相关问答：
我一个项目，有个插入操作，具体是这样的：
如何在SQL2005中设定定时作业，比如说定时清理某些表的数据，
select o_customer,o_price from orders having o_price >=avg(o_price)
我有一个字段是 varchar(1) 类型，二进制表示也就是8位的 ‘0000 0000’
