180.md

Consecutive Numbers

Description

link

---

Solution

See Code

---

Code

# Write your MySQL query statement below
select DISTINCT num  AS "ConsecutiveNums" FROM
(select num,
	case 
		when @record = num then @count:=@count+1
		when @record <> @record:=num then @count:=1 end as n
    from 
	    Logs ,(select @count:=0,@record:=(SELECT num from Logs limit 0,1)) r
) a
where a.n>=3