Purely SQL
Tuesday, 15 November 2011
Difference between Union and Union All in SQL
The main difference between
UNION ALL
and
UNION
is that,
UNION
only selects distinct values, while
UNION ALL
selects all values (including duplicates).
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment