复制SELECT 姓名,查询 Start_HM, End_HM FROM( SELECT b.姓名, MIN (b.日期) Start_HM, MAX (b.日期) End_HM FROM (SELECT a.*, ADD_MONTHS(a.日期, ROWNUM * (-1)) cc FROM (SELECT * FROM t ORDER BY 姓名, 日期 ) a ) b GROUP BY b.姓名, b.cc) WHERE MONTHS_BETWEEN(End_HM,Start_HM) >= 4; 1.2.3.4.5.6.7.8.9.10.