vinyeah · 2005-01-06 09:02:38 · 阅读: 475 再李大师的基础上,偶改了改,现在搞定了 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