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 |
Table1 | Sales |
Website |
| 2900 | http://www.sqltutorials.blogspot.com |
| 3000 | http://beautycentury.blogspot.com |
| 2800 | http://travelyourself.blogspot.com |
Table2 SQL UNION ALL StatementSELECT Sales FROM TABLE1UNION ALLSELECT Sales FROM TABLE2Result
| Sales |
| 2500 |
| 3000 |
| 2800 |
| 2900 |
| 3000 |
| 2800 |
