Informatics Practices

In which type of join, duplicate columns are there ?

  1. Equi-join
  2. Natural
  3. Left Join
  4. Right Join

SQL Joins & Grouping

3 Likes

Answer

Equi-join

Reason — In an equi-join, all columns from the joining tables appear in the output, even if they are identical. This can result in duplicate columns in the output table.

Answered By

3 Likes


Related Questions