SQL UNION ALL is combine the results of two
queries together without filter out the same value(no distinct behavior).
The difference between UNION ALL and
UNION is UNION
only selects distinct values and UNION ALL selects all
values.
Syntax -
UNION ALL
(SQL Statement 1)
UNION ALL
(SQL Statement
2)
Below is example for SQL
UNION
Company | Sales($) | Website |
| Sql Traniner | 2500 | http://www.sqltutorials.blogspot.com |
| BeautyCentury | 3000 | http://beautycentury.blogspot.com |
| TravelYourself | 2800 | http://travelyourself.blogspot.com |
| Sales | Website |
| 2900 | http://www.sqltutorials.blogspot.com |
| 3000 | http://beautycentury.blogspot.com |
| 2800 | http://travelyourself.blogspot.com |
SQL UNION ALL Statement
SELECT Sales FROM TABLE1
UNION ALL
SELECT Sales FROM TABLE2
Result
| Sales |
| 2500 |
| 3000 |
| 2800 |
| 2900 |
| 3000 |
| 2800 |