SQL: Difference between union & union all

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

Hello world!

Welcome to WordPress. This is your first post. Edit or delete it, then start writing!