Bank of America Interview Question

Give an example for self join

Interview Answer

Anonymous

Jan 10, 2016

SELECT a.column_name, b.column_name... FROM table1 a, table1 b WHERE a.common_field = b.common_field;

2