Examveda
Examveda

Which of the following join is also called as an 'inner-join'?

A. Non-Equijoin

B. Self-Join

C. Equijoin

D. None of these

Answer: Option C

Solution(By Examveda Team)

The join known as an 'inner-join' is also referred to as an Equijoin. An Equijoin is a type of join in SQL that combines rows from two or more tables based on a related column between them, using the equal (=) operator. It selects only the rows for which there is a match in both tables. Option C is the correct choice for the join also known as an 'inner-join.' Options A and B are different types of joins, and Option D states that none of these terms refer to an inner-join.

This Question Belongs to SQL >> Sql Miscellaneous

Join The Discussion

Related Questions on Sql Miscellaneous