SELECT DISTINCT
remarks AS ConsecutiveRemarks
FROM
(
SELECT
Id,
remarks,
Lead (remarks, 1) OVER () AS remarks_1,
#选择指定行的向前一行的内容
Lead (remarks, 2) OVER () AS remarks_2 #选择指定行的向前两行的内容
FROM
score
) AS c
WHERE
c.remarks = c.remarks_1
AND c.remarks_1 = c.remarks_2;
连续出现三次的备注信息