SELECT a.team,MIN(Y),MAX(Y) from (SELECT ROW_NUMBER() OVER(ORDER BY team,Y) AS RN,* FROM t) AS a GROUP BY a.team,Y-a.RN HAVING COUNT(Y)>1
SQL如何求解连续性的问题
原文：https://www.cnblogs.com/xiaohuhu/p/13188752.html
