What is the difference between UNION and UNION ALL?

Technology CommunityCategory: SQLWhat is the difference between UNION and UNION ALL?
VietMX Staff asked 3 years ago
  • UNION operation returns only the unique records from the resulting data set
  • UNION ALL will return all the rows, even if one or more rows are duplicated to each other.