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

Oct 19 2020 161

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