想不出来,一看题解就懂

    1. select distinct l1.num ConsecutiveNums
    2. from logs l1,logs l2, logs l3
    3. where
    4. l1.id = l2.id - 1
    5. and l2.id = l3.id - 1
    6. and l1.num = l2.num
    7. and l2.num = l3.num