employer cover photo
employer logo

Aetna interview question

Q: In SQL, what is the difference between a union, join and append?

Interview Answer

Anonymous

1 Nov 2017

A union creates a larger horizontal data set that may have no connection, a join relates two tables that are semantically connected by an index, an append simply adds the contents of one table to the end of another table.