题解 | 连续出现N 次问题【举一反三】

WITH ConsecutiveScores AS (
    SELECT 
        分数,
        LAG(分数, 1) OVER (ORDER BY 学号) AS prev_score1,
        LAG(分数, 2) OVER (ORDER BY 学号) AS prev_score2
    FROM 成绩表
)
SELECT DISTINCT 分数
FROM ConsecutiveScores
WHERE 分数 = prev_score1 AND 分数 = prev_score2

只需要提取出前面第一和第二个数字，看是否和锚定数字相等即可