Leetcode in Java && Oracle
422 subscribers
8 photos
397 files
400 links
Second channel: @codeforces_java

Let's Develop Together!
Download Telegram
image_2022-01-24_17-54-04.png
21.7 KB
#medium

#N180. Consecutive Numbers
problem link

#solution
select distinct l1.num as ConsecutiveNums from
logs l1, logs l2, logs l3
where l1.num=l2.num && l2.num=l3.num && l1.id+1=l2.id && l2.id+1=l3.id;