Wednesday 8 July 2015

Difference between Union and Union All in sql server 2008?

Union gives distinct value from combination of two tables while Union All gives value with duplication from combination of two tables.
In Union result set is sorted in ascending order while In Union All result set is not sorted, two query output gets appended.

No comments:

Post a Comment

Note: only a member of this blog may post a comment.