In this video, we are going to learn about the Amazon SQL Interview Question. How can we find out Consecutive Number in SQL, with the help of Self Joins. Here we will not use any Windows function to solve this problem.
We will solve, how we can get consecutive numbers in SQL with the help of SQL query in detail.
It will be great if you can solve this SQL Problem as this is very important SQL question for product based company, as asked various times in Amazon SQL Interviews and Adobe SQL Interviews.

This will be beneficial for you if you are preparing for the role of data engineer.

Consecutive Numbers in SQL
Consecutives Numbers in SQL
Data enginee sql interview questions
Data analyst sql interview questions
Consecutive Numbers
Consecutive Number
sql Consecutive Numbers
sql Consecutive Number
sql Consecutive
amazon SQL question
adobe SQL question
Deloitte SQL Interview
data analyst interview
deloitte interview
KPMG interview
deloitte sql interview questions
big 4 sql interview questions
pwc sql interview
data analytics sql interview
data analytics
sql interview questions
sql tutorial
sql server interview questions
sql server interview questions and answers
sql interview questions and answers
top sql interview questions and answers
sql interview questions and answers in hindi
sql interview questions
sql query interview questions and answers
sql queries interview questions and answers for experienced
sql interview
sql questions and answers
top sql questions
sql interview questions for freshers
sql interview questions for beginners
sql interview questions for experienced
intermediate level sql interview questions
sql interview preparation
sql basic questions
sql questions
sql query
interview questions sql
interview question sql join
interview questions sql basic

----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------

SCRIPT USED :-

Create table Series (id int, num int);

insert into Series (id, num) values ('1', '1');
insert into Series (id, num) values ('2', '1');
insert into Series (id, num) values ('3', '1');
insert into Series (id, num) values ('4', '2');
insert into Series (id, num) values ('5', '1');
insert into Series (id, num) values ('6', '2');
insert into Series (id, num) values ('7', '2');
insert into Series (id, num) values ('8', '3');


----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------



#dataanalytics #powerbi #sqlinterviewquestions #sql