文章目录
例子1
MySQL/Oracle:
1 | SELECT CONCAT(region_name,store_name) FROM Geography |
结果:
1 | 'EastBoston' |
例子2
Oracle:
1 | SELECT region_name || ' ' || store_name FROM Geography |
结果:
1 | 'East Boston' |
例子3
SQL Server:
1 | SELECT region_name + ' ' + store_name FROM Geography |
结果:
1 | 'East Boston' |