用自连接,
SELECT ... FROM T T1,T T2
WHERE (T1.START BETWEEN T2.START AND T2.END ORT2.START BETWEEN T1.START AND T1.END) AND T1.ID=T2.ID AND T1.ROWIDT2.ROWID
楼上的思路确实不错,涨姿势了
SELECT ... FROM T T1,T T2
WHERE (T1.START BETWEEN T2.START AND T2.END ORT2.START BETWEEN T1.START AND T1.END) AND T1.ID=T2.ID AND T1.ROWIDT2.ROWID