difference between union and union all

set operators in sql

set operations sql