SQL Interview Question and Answers | SWIGGY SQL QUESTION | NTILE() IN SQL | Deepankar Pathak
📊 Mastering SQL Interview Question 📊 Here we are going to discuss SQL Interview Questions, These are the same SQL Interview Questions and answers, that are from the SWIGGY SQL Interview Problem. SQL Interview Question and Answers that have been asked in Amazon for the role of Data Analytic, Here we are going to discuss NTILE windows function and Lag windows function in this Problem. SQL Interview Problem asked during L&T Infotech Interview, Please solve this. NTILE in SQL LAG in SQL String_split in SQL String split in SQL Flipkart Interview Question Amazon Interview Question Myntra Interview Question Intermediate SQL Interview Question data engineer question Myntra Infotech data analytics questions This will benefit you if you prepare for the data engineer role. Data enginee sql interview questions Data analyst sql interview questions 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 Swiggy_Concat ( Order_ID INT, Product_Category VARCHAR(512) ); INSERT INTO Swiggy_Concat (Order_ID, Product_Category) VALUES ('21', 'Fresh Vegetables'), ('22', 'Fresh Fruits'), ('23', 'Rice and Atta'), ('24', 'Bath and Body Care'), ('25', 'Electricals'), ('26', 'Cold Drinks'); --------------------- INPUT ----Order_ID Product_Category ----21 Fresh Vegetables ----22 Fresh Fruits ----23 Rice and Atta ----24 Bath and Body Care ----25 Electricals ----26 Cold Drinks --------------------- OUTPUT ----Result ----21Fresh Vegetables,22Fresh Fruits ----23Rice and Atta,24Bath and Body Care ----25Electricals,26Cold Drinks ---------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------- #dataanalytics #powerbi #sqlinterviewquestions #sql
