What is the difference between UNION ALL and UNION
in SQL server?
by
Thamilselvanj
on
Dec 22, 2011
Category:
SQL Server
|
Level:
Beginner
|
Views:
56
|
Points:
25
|
Silver ★
|
|
|
UNION ALL is used to select all the records from the two tables and the selected column of both table should be same data type but Union is used to select the distinct records from both tables.
|
Like this question? Bookmark and Share:
« Previous Question | Next Question »
|
|
|
|
No Response found!
|
|
|