SQLÓï¾äÌáÎÊ

ÏÖÓÐ±í  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

---

ÒýÓÃ

ÏÖÓÐ±í  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¸ÃÔõôд£¿

·ÖÉÙÇë¼ûÁÂ