在数据库查找一个符合条件的日期(100分)

比如有个表 前两个字段为日期型<br>startdate1 &nbsp; &nbsp;enddate2 &nbsp; &nbsp; &nbsp; value1 &nbsp; value2<br>2008-01-01 &nbsp; &nbsp;2008-02-01 &nbsp; &nbsp; &nbsp;a &nbsp; &nbsp; &nbsp; &nbsp;b<br>2008-03-01 &nbsp; &nbsp;2008-04-01 &nbsp; &nbsp; &nbsp;sdfs &nbsp; &nbsp; fsfsd<br>要用什么语句查找<br>2008-01-15这个日期是属于哪条记录的,SQL语句要怎么写

startdate1&lt;'2008-01-15' AND enddate2&gt;'2008-01-15'

select * from table where statdate1 &lt; '2008-01-15' and enddate2 &gt;'2008-01-15'

select * from table where '2008-01-15' between startdate1 and enddate2

接受答案了.