想不出来,一看题解就懂 select distinct l1.num ConsecutiveNumsfrom logs l1,logs l2, logs l3where l1.id = l2.id - 1 and l2.id = l3.id - 1and l1.num = l2.num and l2.num = l3.num