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