串联多列的值,如mysql中concat的用法。
问题:将多列的值合并为一列。例如将 emp 表中的 ename,job 字段合并。marry work as a managerking work as a presidentandy work as a clerk例如原始数据为:select ename,job from emp where deptno = '1'上述sql结果集为:enameenamejobmarrymanagerkingpresidentandyclerk解决方案