📊 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 Myntra SQL Interview Problem.
Here we will learn about CTE, and Advance CTE in SQL Server.
CTE stands for Common table expression. We will also learn about Running sum in depth, with some advance analysis.
SQL Interview Problem asked during L&T Infotech Interview, Please solve this.
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 Myntra_Problem (
Product_Id INT,
Category VARCHAR(512),
Price INT
);
INSERT INTO Myntra_Problem (Product_Id, Category, Price) VALUES
('1', 'Home & living', '2000'),
('2', 'Home & living', '3500'),
('3', 'Home & living', '15000'),
('4', 'Kids', '1200'),
('5', 'Kids', '1500'),
('6', 'Kids', '6000'),
('7', 'Gifts', '500'),
('8', 'Gifts', '600'),
('9', 'Gifts', '4500');
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
#dataanalytics #powerbi #sqlinterviewquestions #sql
Информация по комментариям в разработке