LeetCode OJ Consecutive Numbers,leetcodeoj
Write a SQL query to find all numbers that appear at least three times consecutively.
+----+-----+ | Id | Num | +----+-----+ | 1 | 1 | | 2 | 1 | | 3 | 1 | | 4 | 2 | | 5 | 1 | | 6 | 2 | | 7 | 2 | +----+-----+
For example, given the above Logs
table, 1
is
the only number that appears consecutively for at least three times.
select distinct a.num from Logs a, Logs b, Logs c where a.id = b.id + 1 and b.id = c.id + 1 and a.num = b.num and b.num = c.num;
本站文章为和通数据库网友分享或者投稿,欢迎任何形式的转载,但请务必注明出处.
同时文章内容如有侵犯了您的权益,请联系QQ:970679559,我们会在尽快处理。