Discussion Forum | Board Infinity

What does union and union all do in SQL?

Sql, Union

  • Union: It combines the result set from multiple tables with eliminating the duplicate records.It performs a distinct on the result set.
  • Union all: It combines the result set from multiple tables without eliminating the duplicate records. it does not perform distinctly on the result set.
1 Like