Home »
MCQs »
Transact-SQL (T-SQL) MCQs
Which of the following types of joins is an intersection of two copies of the same table?
25. Which of the following types of joins is an intersection of two copies of the same table?
- INNER JOIN
- LEFT JOIN
- RIGHT JOIN
- FULL JOIN
- SELF JOIN
- CARTESIAN JOIN
Answer: E) SELF JOIN
Explanation:
SELF JOIN is an intersection of two copies of the same table.