What is difference between Union and Union All in MS SQL?

Dung Do Tien Oct 19 2020 290

What is the difference between Union and Union All in MS SQL Server?

Have 1 answer(s) found.
  • M

    Marry Christ Oct 19 2020

    I think below is some feature difference between Union and Union All:

    UNION: Merge two or more data from Select clause, always remove the duplicate records.

    UNION ALL: Merge two or more data from Select clause, display all duplicate records.

Leave An Answer
* NOTE: You need Login before leave an answer

* Type maximum 2000 characters.

* All comments have to wait approved before display.

* Please polite comment and respect questions and answers of others.

Popular Tips

X Close