Infosys interview question

What is the difference between UNION and UNION ALL?

Interview Answer

Anonymous

7 May 2018

While UNION doesn't select duplicate rows, UNION ALL selects duplicate rows too.