Loading…

Explain the types of joins in SQL?

In SQL, Joins is used to merge records from two or more tables in a database, based on a related column between them.

 

Here are the four types of the joins in SQL

  • INNER JOIN: It returns records that have matching values in both tables
  • LEFT JOIN: It returns all records from the left table and the matched records from the right table
  • RIGHT JOIN: Right Join returns all records from the right table and the matched records from the left table
  • FULL JOIN: It returns all records when there is a match in either left or right table

Suggest An Answer

No suggestions avaliable!

Latest post from SQL Interview Questions

Ask Question