What are joins in SQL? Explain each with a 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.

Asked in Xoriant

What are joins in SQL? Explain each with a real-life example.

Top Associate Software Developer Interview Questions Asked at Xoriant

Interview Questions Asked to Associate Software Developer at Other Companies

Top Skill-Based Questions for Xoriant Associate Software Developer