select ID,MIN(A),MAX(A) from T T1 START WITH NOT EXISTS(SELECT 1 FROM T WHERE A=T1.A-1 AND ID=T1.ID) CONNECT BY PRIOR A=A-1 AND PRIOR ID=ID GROUP BY CONNECT_BY_ROOT(A),ID
17,082
社区成员
55,236
社区内容
加载中
试试用AI创作助手写篇文章吧