mysql两列查询结果列拼接一个表输出_sql select语句，查询出两列结果拼接在一起...

展开全部

1、Oracle创建表，含两列，name和job；create table test_job(name varchar2(30), job varchar2(30));

2、插636f707962616964757a686964616f31333431373839入样例数据；

insert into test_job(name, job) values('ste','teacher');

insert into test_job(name, job) values('jack','driver');

insert into test_job(name, job) values('mick','cooker');

insert into test_job(name, job) values('jacy','driver');

insert into test_job(name, job) values('lucy','boxer');

insert into test_job(name, job) values('john','iter');

3、执行查询语句，数据已插入；select * from TEST_JOB t

4、编辑语句，拼接所需sql；select name||'''s job is '|| job from TEST_JOB t；