what is the difference between union and union all with example?
The only difference between Union and Union All is that Union All will not removes duplicate rows or records, instead, it just selects all the rows from all the tables which meets the conditions of your specifics query and combines them into the result table. UNION doesn't work with a column that has Text Data Type.