UNION & 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
Welcome to WordPress. This is your first post. Edit or delete it, then start writing!