LeetCode: 180. Consecutive Numbers

最新推荐文章于 2022-10-19 08:49:32 发布

杨领well

最新推荐文章于 2022-10-19 08:49:32 发布

阅读量172

点赞数

分类专栏： LeetCode 杨领well的 LeetCode 题解专栏

本文链接：https://blog.csdn.net/yanglingwell/article/details/81812187

版权

LeetCode 同时被 2 个专栏收录

250 篇文章 0 订阅

订阅专栏

杨领well的 LeetCode 题解专栏

241 篇文章 5 订阅

订阅专栏

LeetCode: 180. Consecutive Numbers

题目描述

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               |
+-----------------+

解题思路

将三个 logs 表链接，然后筛选出符合要求的内容。

AC 代码

SELECT DISTINCT logs1.num AS ConsecutiveNums 
FROM logs AS logs1, logs AS logs2, logs As logs3
WHERE logs1.Id = logs2.Id+1 AND logs2.Id = logs3.Id+1 AND logs1.Num = logs2.Num AND logs2.Num = logs3.Num

确定要放弃本次机会？

福利倒计时

: :

立减 ¥

普通VIP年卡可用

立即使用

杨领well

关注关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
复制链接

分享到 QQ

分享到新浪微博

扫一扫

专栏目录

LeetCode每日一题(829. Consecutive Numbers Sum)

wangjun861205的博客

05-19

110

Given an integer n, return the number of ways you can write n as the sum of consecutive positive integers. Example 1: Input: n = 5 Output: 2 Explanation: 5 = 2 + 3 Example 2: Input: n = 9 Output: 3 Explanation: 9 = 4 + 5 = 2 + 3 + 4 Example 3: Input:

[Leetcode] 487. Max Consecutive Ones II 解题报告

魔豆（Magicbean）的博客

12-01

1273

题目： Given a binary array, find the maximum number of consecutive 1s in this array if you can flip at most one 0. Example 1: Input: [1,0,1,1,0] Output: 4 Explanation: Flip the first zero wil

参与评论您还未登录，请先登录后发表或查看评论

leetcode MYSQL数据库题目180

pg的博客

08-22

343

180.Consecutive Numbers １、题目与答案 Write a SQL query to find all numbers that appear at least three times consecutively. 编写SQL查询以查找连续出现至少三次的所有数字 Table:Logs: +----+-----+ | Id | Num | +----+-----...

Leetcode#180. Consecutive Numbers

CongliYin的博客

03-21

296

题目描述：选择下表中连续出现三次的Num作为ConsecutiveNums，Logs表格如下图：结果： SQL语句： select distinct l1.Num as ConsecutiveNums from Logs l1, Logs l2, Logs l3 where l1.Id = l2.Id - 1 and l2.Id = l3.Id - 1 and l1.Num = l...

Leetcode周赛180

Hickey_Chen的博客

03-22

280

1380.Lucky Numbers in a Matrix Given am * nmatrix ofdistinctnumbers, return all lucky numbers in thematrix inanyorder. A lucky number is an element of the matrix such that it is the minim...

leetcode 180. Consecutive Numbers

zyh

05-13

742

题意：投影出连续三个num值相等的元组的num 题目链接：https://leetcode.com/problems/consecutive-numbers/ select distinct l1.num from Logs as l1, Logs as l2, Logs as l3 where l1.Id + 1 = l2.Id and l1.Id + 2 = l3.Id a

leetcode信封-leetcode:leetcode

06-30

leetcode信封 leetcode 目前所完成的leetcode题目 ...Consecutive Ones* 53.7% 695 Max Area of Island* (DFS) 51.8% 283 Move Zeroes* 51.5% 448 Find All Numbers Disappeared in an Array* 51.2% 717

lrucacheleetcode-leetcode:个人刷leetcode遇到的一些题汇总(golang)

06-29

longest-consecutive-sequence max-area-of-island next-greater-element-ii serialize-and-deserialize-binary-tree subarray-sum-equals-k binary-tree-preorder-traversal n-queens-ii populating-next-right-...

leetcode添加元素使和等于-leetcode:leetcode

06-30

Longest_Consecutive_Sequence 双向确认是否连续，避免重复的n^2复杂度 Palindrome_Partitioning DP，避免递归调用，利用数组储存已算出来的数值，由后向前逐渐增加字符串处理 Palindrome_Partitioning_2 同上 Sum_...

【SQL屠夫系列】leetcode-180. 连续出现的数字-(实战扩展：连续登陆N天）

Pushkin.的博客

09-04

2573

【SQL屠夫系列】leetcode-180. 连续出现的数字-(实战扩展：连续登陆N天）

【LeetCode】180.连续出现的数字

wangyucui123的博客

11-04

359

用到的表和数据SQL： CREATE TABLE leetcode.logs ( Id int(11) NOT NULL, Num int(11) ); INSERT INTO leetcode.logs (Id, Num) VALUES (1, 1); INSERT INTO leetcode.logs (Id, Num) VALUES (2, 1); INSERT INTO ...

【leetcode Database】180. Consecutive Numbers

Kevin_zhai的博客

08-08

3802

题目： 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 |

Leetcode180: Majority Element II

12-04

272

Given an integer array of size n, find all elements that appear more than ⌊ n/3 ⌋ times. The algorithm should run in linear time and in O(1) space. 因为不超过n/3个数的数最多只有2个，可以定义两个变量，利用类似Majority Elemen

LeetCode-180.连续出现的数字

DotNeter-Hpf的博客

08-06

190

题目：编写一个 SQL 查询来实现分数排名。表: Scores +----+-------+ | Id | Num | +----+-------+ | 1 | 1 | | 2 | 1 | | 3 | 1 | | 4 | 2 | | 5 | 1 | | 6 | 2 | | 7 | 2 | +----+-------+ 返回如下结果 +---------------------+ | ConsetiveNumscu +---------------------+ | 1 +-------

leetcode-180. 连续出现的数字

思

12-15

258

题目 SQL架构 Create table If Not Exists Logs (Id int, Num int) Truncate table Logs insert into Logs (Id, Num) values ('1', '1') insert into Logs (Id, Num) values ('2', '1') insert into Logs (Id, Num) va...

Leetcode:180 连续出现的数字

handsomem

05-21

178

文章目录一、code1.1 题目描述1.2 题解二、总结一、code 1.1 题目描述 Leetcode地址 1.2 题解 select distinct # 去重 l1.num as ConsecutiveNums from Logs l1, Logs l2, Logs l3 where l1.id + 1 = l2.id # 连续三个 and l2.id = l3.id - 1 and l1.num = l2.num # 值相同

[LeetCode] 180 连续出现的数字

努力变得不菜的菜鸡的博客

12-13

219

1 题目描述编写一个 SQL 查询，查找所有至少连续出现三次的数字。 ±—±----+ | Id | Num | ±—±----+ | 1 | 1 | | 2 | 1 | | 3 | 1 | | 4 | 2 | | 5 | 1 | | 6 | 2 | | 7 | 2 | ±—±----+ 例如，给定上面的 Logs 表， 1 是唯一连续出现至少三次的数...

LeetCode力扣刷题数据库（180）：连续出现得到数字

qq_53933886的博客

10-19

246

LeetCode力扣刷题数据库（180）：连续出现得到数字

leetcode:1.two sum两数之和给定一个整数数组和一个目标值,找出数组中和