我们有例如。下表
| ID | startDateTime | endDateTime |
+----+---------------------+---------------------|
| 1 | 2010-01-01 10:30:00 | 2010-01-01 11:00:00 |
| 2 | 2010-01-01 10:30:00 | 2010-01-01 11:30:00 |
| 3 | 2010-01-01 11:00:00 | 2010-01-01 11:30:00 |
| 4 | 2010-01-01 11:00:00 | 2010-01-01 12:00:00 |
| 5 | 2010-01-01 11:30:00 | 2010-01-01 12:00:00 |
| 6 | 2010-01-01 10:30:00 | 2010-01-01 12:00:00 |
我会例如。查询与
@startDateTime 2010-01-01 11:00:00
@endDateTime 2010-01-01 11:30:00
我想要获得以下 ID:2、3、4、6
我的大脑太古怪了,无法产生正确的陈述......:(
你可以这样做
declare @T table (ID int, startDateTime datetime, endDateTime datetime)
insert into @T values
( 1 , '2010-01-01 10:30:00' , '2010-01-01 11:00:00'),
( 2 , '2010-01-01 10:30:00' , '2010-01-01 11:30:00'),
( 3 , '2010-01-01 11:00:00' , '2010-01-01 11:30:00'),
( 4 , '2010-01-01 11:00:00' , '2010-01-01 12:00:00'),
( 5 , '2010-01-01 11:30:00' , '2010-01-01 12:00:00')
declare @startDateTime datetime
declare @endDateTime datetime
set @startDateTime = '2010-01-01 11:00:00'
set @endDateTime = '2010-01-01 11:30:00'
select *
from @T
where
startDateTime < @endDateTime and
endDateTime > @startDateTime
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)