Pergunta de entrevista da empresa Amazon

What are self joint and why do we use it ?

Resposta da entrevista

Sigiloso

3 de nov. de 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