Question: Write a #sql query to ungroup the data for item counts.
Script:
create table ungroup
(
item_name varchar(20),
item_count int
);
insert into ungroup
values
('Apple',3),
('Orange',6),
('Banana',10);
select * from ungroup;
You can check SQL playlist on my channel for more topics/questions.
Негізгі бет Solving SQL Tricky Interview Question | How To Ungroup Data Inputs | Recursive CTE SQL Query
Пікірлер: 2