请教各位大大,怎么统计记录中连续3次为赢分的用户(也就是连赢3局的用户)

[jhlovett]

UserID为用户的ID,Score为输赢分(正数为赢分,负数为输分)

请教各位大大,怎么统计记录中连续3次为赢分的用户(也就是连赢3局的用户)
连续3次为输分的用户(也就是连输3局的用户)

[中国风]

Type=-1为负数,1为正数,0为0 e.g.

;
WITH    CTET
          AS ( SELECT   UserID ,
                        Score ,
                        SIGN(Score) AS Type ,
                        ROW_NUMBER() OVER ( PARTITION BY RAND() ) AS Ord
               FROM     Table1
             )
    SELECT DISTINCT
            UserID
			,Type
    FROM    ( SELECT    * ,
                        ROW_NUMBER() OVER ( PARTITION BY UserID, Type ORDER BY Ord ) AS Ord2
              FROM      CTET
            ) AS t
    GROUP BY UserID ,Type
            Ord - Ord2
    HAVING  COUNT(*) >= 3;