LeetCode 0180 - Consecutive Numbers

Reck Zhang

发布于 2021-08-11 14:52:57

1810

发布于 2021-08-11 14:52:57

文章被收录于专栏：Reck Zhang

Consecutive Numbers

Desicription

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.

+-----------------+
| ConsecutiveNums |
+-----------------+
| 1               |
+-----------------+

Solution

SELECT DISTINCT L1.Num
AS ConsecutiveNums
from Logs L1, Logs L2, Logs L3
WHERE L1.Num = l2.Num AND L1.Num = L3.num AND L1.Id = L2.Id-1 AND L1.Id = L3.Id+1

本文参与腾讯云自媒体同步曝光计划，分享自作者个人站点/博客。

原始发表：2018-06-04，如有侵权请联系 cloudcommunity@tencent.com 删除

sql

numbers

table

本文分享自作者个人站点/博客前往查看

如有侵权，请联系 cloudcommunity@tencent.com 删除。

本文参与腾讯云自媒体同步曝光计划，欢迎热爱写作的你一起参与！

sql

numbers

table

登录后参与评论

0 条评论

热度

LeetCode 0180 - Consecutive Numbers

LeetCode 0180 - Consecutive Numbers

Consecutive Numbers

Desicription

Solution

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐