INNER JOIN vs IN | IN vs EXISTS | NOT IN vs NOT EXISTS | EXISTS() | NOT EXISTS() | SQL OPERATOR

INNER JOIN vs IN | IN vs EXISTS | NOT IN vs NOT EXISTS | EXISTS() | NOT EXISTS() | SQL OPERATOR Agenda: --------------- Q01. What is the difference between INNER JOIN and IN() operator in MS SQL? Q02. What is the difference between IN() and NOT IN() operators in MS SQL? Q03. What is the NULL value impact in IN() or NOT IN() operator in MS SQL? Q04. What is the difference between IN() operator and multiple OR conditions? Q05. Does IN() or NOT IN() operator use index in MS SQL? Q06. Does nested IN() operator allowed in MS SQL? Q07. What will happen if there are duplicate values in IN() operator? Q08. What is the difference between IN() and EXISTS() in MS SQL? Q09. What is the difference between NOT IN() and NOT EXISTS() in MS SQL? Q10. What is LEFT SEMI JOIN in SQL? How it differs from INNER and LEFT JOIN? A LEFT SEMI JOIN can only return columns from the left table, and yields one of each record from the left table where there is one or more matches in the right t