1.7 连接列值

问题:

查询多列的值,在一列上显示

解决方案:

select ENAME + 'work as a '+ job as msg from EMP where DEPTNO = 10;

结果:

最后更新于