Full Outer Join in Depth Tutorial | Advanced SQL Tutorial

Опубликовано: 10 Октябрь 2024
на канале: Ankit Bansal

8,131

354

In this video we will discuss in depth full outer join in SQL and its challenges. We will also see 2 better alternatives of full outer join specially when you need to join more than 2 tables.
00:00 setting up the context
03:35 Challenges with full outer join
16:40 alternative 1 (traditional)
23:15 alternative 2 (super cool trick)

scripts:
create table product_master
(
product_id int,
product_name varchar(100)
);

insert into product_master values(100,'iphone5'),(200,'hp laptop'),(300,'dell laptop');

create table orders_usa
(
order_id int,
product_id int,
sales int
);
create table orders_europe
(
order_id int,
product_id int,
sales int
);

create table orders_india
(
order_id int,
product_id int,
sales int
);
--delete from orders_india
insert into orders_usa values (1,100,500);
insert into orders_usa values (7,100,500);
insert into orders_europe values (2,200,600);
insert into orders_india values (3,100,500);
insert into orders_india values (4,200,600);
insert into orders_india values (8,100,500);

Zero to hero(Advance) SQL Aggregation:
   • All About SQL Aggregations | SQL Adva...

Most Asked Join Based Interview Question:
   • Most Asked SQL JOIN based Interview Q...

Solving 4 Trick SQL problems:
   • Solving 4 Tricky SQL Problems

Data Analyst Spotify Case Study:
   • Data Analyst Spotify Case Study | SQL...

Top 10 SQL interview Questions:
   • Top 10 SQL interview Questions and An...

Interview Question based on FULL OUTER JOIN:
   • SQL Interview Question Based on Full ...

Playlist to master SQL :
   • Complex SQL Questions for Interview P...

Rank, Dense_Rank and Row_Number:
   • RANK, DENSE_RANK, ROW_NUMBER SQL Anal...

#sql #fullouterjoin #unionall