SQL如何求解连续性的问题
时间：2021-07-01 10:21:17
帮助过：6人阅读
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
