现有表 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中设定定时作业，比如说定时清理某些表的数据，
字段1,字段2.....字段N,Status,ParentID
各位好，我刚把一个ASP网站设置好了，也能正常访问。但是在我本机上不能打开admin\login.asp,所以无法实现后台管理。（错误提示无法找到网页，代码404，我的操作系统是win2000 server)
select o_customer,o_price from orders having o_price >=avg(o_price)
在Access的查询中执行下面的语句,无效,提示期待select ,updata ,...
