LeetCode | Consecutive Numbers
来源:互联网 发布:网络大电影宣发公司 编辑:程序博客网 时间:2024/06/15 14:30
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 FROM (
SELECT Num, COUNT(Rank) AS Cnt FROM (
SELECT Num,
@curRank := @curRank + IF(@prevNum = Num, 0, 1) AS rank, @prevNum := Num
FROM Logs s, (SELECT @curRank := 0) r, (SELECT @prevNum := NULL) p
ORDER BY ID ASC
) t GROUP BY Rank HAVING Cnt >= 3
) n;
应该好好看看MySQL用户定义变量和聚组函数了
0 0
- 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 180. Consecutive Numbers
- 【Leetcode】Consecutive Numbers
- leetcode-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 180. Consecutive Numbers 解题思路
- 九度Online Judge求职面试题集及解题思路
- firefox使用小技巧
- PhpExcel中文帮助手册|PhpExcel使用方法
- Java RuntimeException类几点说明
- 数据结构实验五——栈实现数制转换
- LeetCode | Consecutive Numbers
- CentOS安装sendmail及设置
- Java正则表达式详解
- 粒子系统
- Microsoft Linux ?
- Inline Functions versus Macros
- myeclipse创建的工程eclipse无法正常部署
- POJ2299(归并排序求逆序对)
- Bootstrap--对移动设备友好的布局