SQL如何求解连续性的问题

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如何求解连续性的问题

标签：inf   http   ima   number   sele   order   com   style   select