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