1:合并列
Employees_Norway:
E_ID | E_Name |
---|---|
01 | Hansen, Ola |
02 | Svendson, Tove |
03 | Svendson, Stephen |
04 | Pettersen, Kari |
Employees_USA:
E_ID | E_Name |
---|---|
01 | Turner, Sally |
02 | Kent, Clark |
03 | Svendson, Stephen |
04 | Scott, Stephen |
SQL Union和SQL Union All
2:合并行
a---------select concat(aaa,bbb) as colc from table_name;
b---------select aaa||bbb as colc from table_name;