What are different types of joins in SQL

All Subject

Question - What are different types of joins in SQL?

Answer -

There are 4 types of SQL Joins:

Inner Join: This type of join is used to fetch the data among the tables which are common in both the tables.
Left Join: This returns all the rows from the table which is on the left side of the join but only the matching rows from the table which is on the right side of the join.
Right Join: This returns all the rows from the table which is on the right side of the join but only the matching rows from the table which is on the left side of the join.
Full Join: This returns the rows from all the tables on which the join condition has put and the rows which do not match hold null values.

Show all Coment

Name:

Email:

DBMS Interview Questions and Answers