【leetcode刷题】mysql题库

最新推荐文章于 2022-09-14 22:40:09 发布

weixin_30782331

最新推荐文章于 2022-09-14 22:40:09 发布

阅读量187

点赞数

文章标签：数据库

原文链接：http://www.cnblogs.com/AHappyBird/p/10574080.html

版权

IFNULL(exp1, exp2)

如果存在exp1则展示exp1，如果没有输出exp2

cast

convert

# Write your MySQL query statement below
select DISTINCT
Num as ConsecutiveNums
from
(
select
Num,
( CASE WHEN Num = @curNum THEN @counter := @counter + 1 WHEN @curNum :=Num THEN @counter := 1 END ) as counter
from
Logs,
( select @curNum := NULL, @counter := 0 ) as q
) as a
where
counter >= 3

https://www.cnblogs.com/dannylinux/articles/8288790.html

转载于:https://www.cnblogs.com/AHappyBird/p/10574080.html