17,086
社区成员
发帖
与我相关
我的任务
分享
--表名为tab
SELECT t.*
FROM tab t,
(SELECT a.id aid, b.id bid
FROM tab a, tab b
WHERE a.name = b.name AND
b.start < a.start AND
a.end < b.end) c
WHERE t.id = c.aid OR
t.id = c.bid;
SELECT a.*, b.*
FROM tab a, tab b
WHERE a.name = b.name AND
b.start < a.start AND
a.end < b.end