Accenture SQL Interview Question | SELF JOIN and WINDOWS Function in SQL | Deepankar Pathak

In this video, we will learn about the Accenture SQL Interview Question.

How can we apply SELF JOIN and WINDOWS Functions, with the help of Advance Function. Here we will learn about how we can apply self join and how can we find out duplicate records on the basis of certain conditions.

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 BIG 4 organization SQL interviews.

This will be beneficial for you if you are preparing for the role of data engineer and data analyst
Accenture SQL Interview Question for data analytics
Accenture SQL Interview Question for data engineer
Accenture SQL Interview Question /SELF JOIN and WINDOWS Function in SQL
accenture SQL question
accenture SQL question
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

----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
CREATE TABLE Student_raw (
Student_id VARCHAR(512),
Name VARCHAR(512),
Fees INT,
Section VARCHAR(512)
);

INSERT INTO Student_raw (Student_id, Name, Fees, Section) VALUES ('14EAR1', 'Rohan', '2000', 'B');
INSERT INTO Student_raw (Student_id, Name, Fees, Section) VALUES ('14EAR2', 'Navdeep', '1500', 'A');
INSERT INTO Student_raw (Student_id, Name, Fees, Section) VALUES ('14EAR3', 'Sohan', '2000', 'B');
INSERT INTO Student_raw (Student_id, Name, Fees, Section) VALUES ('14EAR4', 'Mohan', '5000', 'C');
INSERT INTO Student_raw (Student_id, Name, Fees, Section) VALUES ('14EAR5', 'Swapnil', '4000', 'D');
INSERT INTO Student_raw (Student_id, Name, Fees, Section) VALUES ('14EAR6', 'Tapu', '5000', 'C');
INSERT INTO Student_raw (Student_id, Name, Fees, Section) VALUES ('14EAR7', 'Goli', '4000', 'D');




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



#dataanalytics #powerbi #sqlinterviewquestions #sql