What is the difference between UNION and UNION ALL?

Correct Answer: UNION selects only distinct values whereas UNION ALL selects all values and not just distinct ones