Leetcode180 Consecutive Numbers

Posted on 2020-02-22 Edited on 2020-02-26 In 数据库 Valine:

Problem:

Solution:

SELECT *
FROM
    Logs l1,
    Logs l2,
    Logs l3
WHERE
    l1.Id = l2.Id - 1
    AND l2.Id = l3.Id - 1
    AND l1.Num = l2.Num
    AND l2.Num = l3.Num
;