Use of UNION and UNION ALL Operator in SQL
UNION and UNION ALL Operator in SQL: (1) “UNION” & “UNION ALL” operators are used to combine two SELECT statement results. (2) The difference between “UNION” and UNION ALL” is that “UNION” select only unique values from two columns having the same datatype and same sequence whereas “UNION ALL” select all values whether it is duplicate …