SELECT a.*, b.*
  FROM tab a, tab b
 WHERE a.name = b.name AND
       b.start < a.start AND
       a.end < b.end

------解决方案--------------------

如果要按原表字段显示，可以
SQL code
--表名为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;