#sql Interview Questions - All JOINS (INNER, LEFT, RIGHT, FULL OUTER) | JOIN only NULL values output

Hi All,
This is Ankit Shrivastava and today this #vlog is regarding mostly asked #sql #sqlinterviewquestions .

This #vlog is regarding is All the SQL joins INNER LEFT, RIGHT, FULL OUTER on NOT NULL as well as NULL values.
This is very common SQL interview question in which interviewer will check your understanding on all the joins and that too with #null values and as well as #notnull values.

Please find the executed SQL code from this video

create table emp2 (emp_id integer,emp_name varchar(50),dept varchar(20),salary integer);
insert into emp1 values (100,'Ankit','IT',1000);
insert into emp1 values (101,'Amit','IT',1000);
insert into emp1 values (102,'Saurabh','HR',2000);
insert into emp1 values (103,'Varun','HR',4000);
insert into emp1 values (104,'Farhan','SALES',4000);
insert into emp1 values (105,'Aman','Operations',5000);
insert into emp1 values (106,'Diwakar',null,null);
insert into emp1 values (null,null,null,null);

insert into emp2 values (100,'Ankit','IT',1000);
insert into emp2 values (101,'Amit','IT',1000);
insert into emp2 values (102,'Saurabh','HR',2000);
insert into emp2 values (103,'Varun','HR',4000);
insert into emp2 values (107,'Mike','SALES',4000);
insert into emp2 values (108,'Marc','Operations',5000);
insert into emp2 values (109,'John',null,null);
insert into emp2 values (null,null,null,null);

#sqlinterviewquestions #sqlinterviewquestionsandanswers
#sql #innerjoin #leftjoin #rightjoin #fullouterjoin
#trendinginterview #interview #oracle #interviewtips #mysql #interviewready #interviewpreparation #sqljoins #null #notnull
#sqlserver #sqlservermanagementstudio #etltesting #databaseexercises #databasetesting #testing #data #dataengineering #dataengineer #twitter #elonmusk #sqlserverdba #microsoft #postgresql #postgres #value #null

[Vithobha]

Great information! Could you also share the video for the difference between equi join and natural join? Thank you in advance 😊

[subbaraoballipale]

for cross jion nulls will be ingnored right ?

[zameerahmed]

Hi .... Wat is the name of this SQL IDE ???