2
Reply

Difference between Union and Union All in SQL?

Manikandan Murugesan

Manikandan Murugesan
2y
1.3k
0
Reply
    Tharunkumar Magudeeswaran
    Union -> It combines only unique rows. Performance is slower due to this. Union All -> It combines all rows. Performance will be better as it combines all rows.
    Tharunkumar Magudeeswaran
    Jan 31
    0
    Umang Pawar

    Union - returns all the values from 2 queries excluding dups
    Union All - returna all the values from 2 queries including dups

    Umang Pawar
    2y
    0
Message