difference between union and union all in sql

set operators in sql

set operations sql