SELECT f.num, f.cir Continuation, f.MIN, f.max FROM ( SELECT num,cir,MIN,MAX FROM ( SELECT num, MIN(id) AS MIN, MAX(id) AS MAX, COUNT(ir) AS cir FROM (SELECT num, rnk, id, (id - rnk) AS ir FROM ( SELECT id, num, row_number() over(partition BY num order by id) AS rnk FROM dev.dev_zsz_lianxi ) a ) b GROUP BY num, ir ) c ) f JOIN ( SELECT num, MAX(cir) Continuation FROM ( SELECT num, COUNT(ir) AS cir FROM ( SELECT num, rnk, id, (id - rnk) AS ir FROM ( SELECT id, num, row_number() over(partition BY num order by id) AS rnk FROM dev.dev_zsz_lianxi ) a ) b GROUP BY num, ir ) c GROUP BY num ) h ON f.num = h.num AND f.cir = h.Continuation 貌似很麻烦的样子。。。