UNION selects only distinct values whereas UNION ALL selects all values and not just distinct ones.
----------------------------Union------------------------------------
SELECT column_names FROM table_name1
UNION
SELECT column_names FROM table_name2
UNION
SELECT column_names FROM table_name2
-----------------------------Union All--------------------------------
SELECT column_names FROM table_name1
UNION ALL
SELECT column_names FROM table_name2
SELECT column_names FROM table_name1
UNION ALL
SELECT column_names FROM table_name2
No comments:
Post a Comment