Data Engineer 面试题与答案

Question: What is the difference between a left join and an inner join in SQL?

Answer: An inner join returns only the rows where there is a match in both tables, while a left join returns all rows from the left table and the matched rows from the right table.

Example:

Selecting all customers and their orders, even if some customers have not placed any orders (left join).