How UNION differs from UNION ALL?
Explanation
The UNION / UNION ALL operators are used to combine the result-sets of two or more SELECT statements.
The difference between two of them is that he UNION operator selects only distinct values by default. To allow duplicate values, UNION ALL should be used.

Follow CodeGalaxy

Mobile Beta

Get it on Google Play
Send Feedback