Скачать или смотреть 180. Consecutive Numbers | LeetCode | Hindi | Top 50 sql interview questions

Find all numbers that appear at least three times consecutively.
Return the result table in any order.

problem link - https://leetcode.com/problems/consecu...

LEAD (expression [, offset [, default]]) OVER (
-- [PARTITION BY partition_expression, ... ]
-- ORDER BY sort_expression [ASC | DESC], ...
-- )
]\=
======= Approach 1 ======
with cte as (
select num,
lead(num,1) over(order by id) num1,
lead(num,2) over(order by id) num2
from logs
)
select distinct num ConsecutiveNums from cte where (num=num1) and (num=num2)

======= Approach 2 =======
select distinct a.num as ConsecutiveNums from logs a where a.num =(select num from Logs where id=a.id+1)
AND a.num=(select num from logs where id=a.id+2)


#leetcodesql #FAANG #SQLinterviewQuestions
⭐Hashtags⭐
#sql #sqlinterviewquestions #sqlinterviewquestionsandanswers #sqlquestions

Related keywords
sql interview questions
sql interview questions and answers
sql interview
sql questions and answers
top sql questions
sql rishabh mishra
sql interview questions for freshers
sql interview questions for beginners
sql interview questions for experienced
intermediate level sql interview questions
sql queries interview questions and answers
sql interview preparation
sql basic questions
sql questions
sql query
interview questions sql
interview question sql join
interview questions sql basic
Advanced SQL Interview Questions Answer
Top 10 SQL Interview Questions Answer
SQL Interview Questions in hindi
SQL Interview Questions and answers for Freshers and Experienced
Top 10 SQL Interview Questions Answer
SQL Interview Questions Answer
SQL Interview hindi
SQL Interview Questions for freshers
SQL Interview Questions and answers for freshers
SQL Roadmap 2023
SQL Interview Questions 2023
SQL Interview Experience Interview questions for SQL Experienced
BEST SQL Interview Questions
Top 10 SQL interview Questions and Answers | SQL Interview Questions