Union
|
Union ALL
|
Union only selects distinct values.
|
Union all select all values in the table.
|
Union removes duplicate rows.
|
Union all doesn’t removes duplicate
rows.
|
Output is in sorted order so that it
is faster.
|
Output is not sorted order.
|
No comments:
Post a Comment