Contents
hide
union vs union all
are SQL Operators to concatenate One or more result sets. The difference between them is that Union keeps only unique records while Union All extracts all the rows including duplicates. When using UNION instead of UNION ALL, database server must do additional work to remove the duplicate rows
