SQL Interview Question for Product Based Company | Advance Pivot | 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 SQL Interview Question for Product Based Company.

Advance Pivot in SQL Server

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 Food_Delivery (
Food_Item VARCHAR(512),
Delivery_Partner VARCHAR(512)
);

INSERT INTO Food_Delivery (Food_Item, Delivery_Partner) VALUES
('Sweets', 'Zomato'),
('Fruits', 'BlinkIt'),
('Samosa', 'Swiggy'),
('Kachori', 'Zomato'),
('Biscuit', 'BlinkIt');
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------

#dataanalytics #powerbi #sqlinterviewquestions #sql

[vijay.s-llyq]

with cte as
(select *, row_number() over
(partition by Delivery_Partner order by Food_Item ) rn from Food_Delivery)

select rn,
max (case
when Delivery_Partner ='BlinkIt' then Food_item else null end) as BlinkIt,
max(case
when Delivery_Partner ='Swiggy' then Food_item else null end) as Swiggy,
max (case
when Delivery_Partner ='Zomato' then Food_item else null end) as Zomato

from cte
group by rn

[chandanpatra]

Since we have 3 delivery_partner so we have hardcoded those values. What if we have 20/30/40 delivery_partners. Are we going to hardcode it 20times or 30 times. This is not possible. Please bring a dynamic solution to it. As someone has commented regarding the same.Please bring up some other approach for this question.
Anyway very good question.

[vikrantheswar]

This solution is not dynamic. Instead of this way, we can directly utilise PIVOT function in sql

[theinsightminer]

SELECT
MAX(CASE WHEN Delivery_Partner ='BlinkIt' THEN Food_Item END)AS Blinkit,
MAX(CASE WHEN Delivery_Partner ='Swiggy' THEN Food_Item END) AS Swiggy,
MAX(CASE WHEN Delivery_Partner ='Zomato' THEN Food_Item END) AS Zomato
FROM
(SELECT
*,
ROW_NUMBER() OVER(PARTITION BY Delivery_Partner ORDER BY Food_Item) AS rn
FROM Food_Delivery) AS food_delivery_subquery
GROUP BY rn;