1.sqlserver
使用 + 运算符进行连接操作
select ename + 'work as a' + job as msg from emp where deptno=10
2.Oracle,DB2,PostgreSQL
select * ename || 'work as a' || job as msg from emp where deptno=10
3.mySQL
支出contact函数
select contact(ename, 'work as',job)as msg from emp where deptno=10