f1 | f2 | f3 | f4 | f5 |
---|---|---|---|---|
1 | 1 | 1 | a | 3 |
1 | 1 | 1 | b | 1 |
1 | 1 | 1 | c | 11 |
1 | 2 | 1 | e | 3 |
1 | 2 | 1 | d | 1 |
1 | 2 | 1 | c | 15 |
f1 | f2 | f3 | f4 | f5 |
---|---|---|---|---|
1 | 1 | 1 | c | 11 |
1 | 2 | 1 | c | 15 |
f1 | f2 | f3 | f4 | f5 |
---|---|---|---|---|
1 | 1 | 1 | c | 11 |
f1 | f2 | f3 | f4 | f5 |
---|---|---|---|---|
1 | 1 | 1 | c | 11 |
1 | 2 | 1 | NULL | NULL |
select 1 As f1, 1 As f2, 1 As f3, 'c' As f4, '11' As f5
union
select 1 As f1, 2 As f2, 1 As f3, null As f4, null As f5