In this video we will discuss SQL Join based interview question where you need to say no of records in output when you join 2 tables. This question is very important from interview point of view as well join understanding point of view. It is a must watch concept.
Create table TA (IDA Nvarchar(5) )
Create table TB (IDB Nvarchar(5) )
insert into TA values(1)
insert into TA values(1)
insert into TA values(2)
insert into TA values(3)
insert into TA values(3)
insert into TA values('Null')
insert into TA values('Null')
insert into TB values(1)
insert into TB values(2)
insert into TB values(4)
insert into TB values('Null')
Select * from TA
Select * from TB
Select * from TA inner join TB on IDA=IDB
Select * from TA Left join TB on IDA=IDB
Select * from TA Right join TB on IDA=IDB
Select * from TA Full outer join TB on IDA=IDB
Referance Video:
SQL Interview Question | Print Movie Stars (⭐ ⭐ ⭐ ⭐⭐) For best movie in each Genre ! Top SQL !
[ Ссылка ]
How to Identify and Delete Duplicate Records in SQL | Easy Explanation with Real Time Scenarios
[ Ссылка ]
Ещё видео!