Home »
MCQs »
HSQLDB MCQs
Which of the following type of join returns all rows from the right table even if no matches are found in the left table?
37. Which of the following type of join returns all rows from the right table even if no matches are found in the left table?
- LEFT JOIN
- INNER JOIN
- RIGHT JOIN
Answer: C) RIGHT JOIN
Explanation:
RIGHT JOIN returns all rows from the right table even if no matches are found in the left table.