leetcode 180. Consecutive Numbers 解题思路
来源:互联网 发布:软件代理加盟 编辑:程序博客网 时间:2024/06/03 21:14
题目如下:
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 Num as ConsecutiveNums from Logs as l
where l.num =
(select num from Logs as p where l.id+2=p.id )
&&
l.num =
(select num from Logs as p where l.id+1=p.id )
简单粗暴- -。判断连续三个是否num相等。
0 0
- leetcode 180. Consecutive Numbers 解题思路
- leetcode 180. Consecutive Numbers
- leetcode 180. Consecutive Numbers
- Leetcode 180. Consecutive Numbers
- leetcode-database-180. Consecutive Numbers
- 【leetcode Database】180. Consecutive Numbers
- LEETCODE SQL题目 180. Consecutive Numbers
- LeetCode | Consecutive Numbers
- [leetcode] Consecutive Numbers
- LeetCode:Consecutive Numbers
- Leetcode:Consecutive Numbers
- [LeetCode] Consecutive Numbers - SQL
- Leetcode: Consecutive Numbers
- [LeetCode][Database]Consecutive Numbers
- LeetCode OJ Consecutive Numbers
- [Leetcode] [Database] Consecutive Numbers
- 【Leetcode】Consecutive Numbers
- leetcode-Consecutive numbers
- LeetCode-173. Binary Search Tree Iterator (JAVA)BST的迭代
- 段错误原因收集
- 1020. 月饼 (25)
- hive 调优
- java 基础思维导图
- leetcode 180. Consecutive Numbers 解题思路
- 十分钟pandas(数据透视、矩阵合并、读写文件)
- 剑指offer(java代码)——变态跳台阶
- 关于c++的一些话题
- 图形制作
- Mybatis 解决字段名与实体类属性名不相同的冲突
- 图论算法----二分图匹配----匈牙利算法详解
- c语言 【鱼c】c语言零基础入门教学视频
- 一个满屏品字布局怎么设计?