Domanda di colloquio di Infosys

What is the difference between UNION and UNION ALL?

Risposta di colloquio

Anonimo

7 mag 2018

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