中国开发网: 论坛: 程序员情感CBD: 贴子 76433
vinyeah
再李大师的基础上,偶改了改,现在搞定了
select * from (
select SDate, EDate,
(Select count(*) from TableA as T2
WHERE (T2.SDate < T1.SDate and T2.EDate > T1.SDate)
or (T2.SDate < T1.EDate and T2.EDate> T1.EDate)
) as cnt
from TableA as T1
)
where cnt > 0

相关信息:


欢迎光临本社区,您还没有登录,不能发贴子。请在 这里登录