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.
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.