SQL-Course/union_all_set_operator.sql at main · techysanoj/SQL-Course · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
use temp_db;

show tables;

select * from t1;
select * from t2;

-- union all operator
select * from t1
union all
select * from t2; -- this does not delete duplicates from the data
-- this will allow the duplicates to come in the final output

select * from emp1;
select * from emp2;
select * from emp3;

select * from emp1
union all
select * from emp2; -- check difference between this and union