Amazon Interview Question

What are self joint and why do we use it ?

Interview Answer

Anonymous

Nov 3, 2017

Self joins are used to join data from the same table. One example of how this is useful is in an attempt to check for duplicate records. Joining on the primary key of the table displays the circumstances where more than one field exists for that record.

1