#sql

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

[@saurabhraj922]

Well explained 👍👍

[@dailylifeofadataengineer7742]

Thank you Saurabh

[@Vithobha]

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

[@dailylifeofadataengineer7742]

Thanks for the feedback. Sure I will share another video on difference between equi join and natural join very soon.

[@subbaraoballipale890]

for cross jion nulls will be ingnored right ?

[@zameerahmed1775]

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