What are joins in SQL? Explain each with the real life example?

Question

Accepted Answer

Joins in SQL are used to combine data from two or more tables based on a related column.

Inner join returns only the matching rows from both tables.
Left join returns all the rows from the left table and matching rows from the right table.
Right join returns all the rows from the right table and matching rows from the left table.
Full outer join returns all the rows from both tables.
Example: Inner join can be used to combine customer and order tables based on customer ID.

Accepted Answer

LEFT JOIN (LEFT OUTER JOIN) – Returns all rows from the left table and matching rows from the right.
RIGHT JOIN (RIGHT OUTER JOIN) – Returns all rows from the right table and matching rows from the left.
FULL JOIN (FULL OUTER JOIN) – Returns all rows when there is a match in either table.
CROSS JOIN – Returns the Cartesian product of both tables.
SELF JOIN – Joins a table with itself.

What are joins in SQL? Explain each with the real life example?

Top Xoriant Associate Software Developer interview questions & answers

Popular interview questions of Associate Software Developer

Top HR questions asked in Xoriant Associate Software Developer