When will union and union all behave the same?

Question

Anonymous User · Answer

Union will return record only once even if it occurs several times. Union all will give a record as many times as it occurs. So union and union all will behave the same when each record is distinct in all the participating tables.
egselect name, id from Emp1 union select name, id from Emp2
select name, id from Emp1 union all select name, id from Emp2

interview

When will union and union all behave the same?

Anonymous User

Can you answer this question?

1 Answers

Liked By