方式一
SELECT DISTINCT
l1.Num ConsecutiveNums
FROM
LOGS l1
LEFT JOIN LOGS l2 ON l1.Id = l2.Id - 1
LEFT JOIN LOGS l3 ON l1.Id = l3.Id - 2
WHERE
l1.Num = l2.Num AND l2.Num = l3.Num;
方式一
SELECT DISTINCT
l1.Num ConsecutiveNums
FROM
LOGS l1
LEFT JOIN LOGS l2 ON l1.Id = l2.Id - 1
LEFT JOIN LOGS l3 ON l1.Id = l3.Id - 2
WHERE
l1.Num = l2.Num AND l2.Num = l3.Num;
转载于:https://my.oschina.net/u/3424826/blog/1843750