Consecutive Numbers | Leetcode 180 | Crack SQL Interviews in 50 Qs

[@learnwithchirag]

Hey there! 👋 For more interesting content, tutorials, and updates, Feel free to connect with me on
Instagram Handles :-
@createwithchirag - instagram.com/createwithchirag/
@learn.with.chirag - instagram.com/learn.with.chirag/
LinkedIn: www.linkedin.com/in/chirag-sehgal-9200111b8/
Let's stay connected and keep the creativity flowing! 💡

[@uncreativeovertake]

Hello Sir,
In this, If we have given that appears num at-least 10 times or more then 10 times , then which approach will apply?

[@apoorvpradhan5125]

Thanks bhaiya !

[@MayankRathore-qi7qv]

select distinct num as ConsecutiveNums
from Logs
where id in (select id from logs where id =3 ) i try to do this but after 15 test case it doest not work
pls give advice where i mistake

[@abhishekpatwal3827]

We can also use lead()

[@learnwithchirag]

Yes , there can be many ways of solving a question in SQL.... Do share your solution here , It will help others .....
Keep watching 🎉

[@rishavraj7318]

Thanks and one suggestion is try to explain more on the logical part even if video gets long.

[@learnwithchirag]

Sure Noted 👍 Will do it and glad the video was helpful 💯💐

[@mohammedmaqdoom4410]

thanks chirag this side

[@learnwithchirag]

Glad it was helpful to you 💐

[@gautammakharia6545]

SELECT DISTINCT num AS ConsecutiveNums
FROM (
SELECT num,
LAG(num, 1) OVER (ORDER BY id) AS prev_num,
LEAD(num, 1) OVER (ORDER BY id) AS next_num
FROM Logs
) AS temp
WHERE num = prev_num AND num = next_num;

[@shivamshukla9745]

use group by l1.num for the submission or generalized answer

[@redeagle6580]

try to use diagrams and flowchart

[@learnwithchirag]

Sure buddy..... I will try to add it to my upcoming videos...💫

[@nimbu_03]

Got Stuck.... noice

[@learnwithchirag]

Atleast you tried 💯

[@adarshjha5126]

Bhai pahale smajhaya jata hai fhir query likhte hai

[@nishukaira5563]

achha bhai

[@akhilpratapsingh3223]

[@learnwithchirag]

💯