LatentView Analytics Very Tricky SQL Interview Question | SQL Question for Data Engineering
LatentView Analytics Very Tricky SQL Interview Question | SQL Question for Data Engineer
In this video, I will show you how I solved a very tricky SQL interview question asked to me by LatentView Analytics .
Input:
with data as (
select "A" as class, "Maths" as sub union all
select "B", "English" union all
select "A", "Social" union all
select "B", "Chemistry" union all
select "A","Physics" union all
select "B", "Statistics" union all
select "A", "Biology" union all
select "B", "Maths" union all
select "A", "Science" union all
select "B", "Social"
)
Output:
-- Class Sub1 Sub2 Sub3 Sub4 Sub5
-- A Science Physics Social Maths Biology
-- B English Social Maths Statistics Chemistry
En esta página del sitio puede ver el video en línea LatentView Analytics Very Tricky SQL Interview Question | SQL Question for Data Engineering de Duración hora minuto segunda en buena calidad , que subió el usuario DataTechWhiz 22 agosto 2024, comparta el enlace con amigos y conocidos, en youtube este video ya ha sido visto 1,602 veces y le gustó 42 a los espectadores. Disfruta viendo!
