Both UNION and UNION ALL are used to combine the results generated by multiple SELECT statements.
UNION is the function that eliminates duplicates in the table
UNION ALL retains the duplicates
