/***
id name
1 a
2 b
3 c
3 d
用一条sql 得出
ab
ac
ad
bc
bd
cdi
一下是oracle 的写法
insert into t1 values(1,'a');
insert into t1 values(2,'b');
insert into t1 values(3,'c');
insert into t1 values(3,'d');
select a.remark || b.remark from t1 a ,t1 b where a.remark <> b.remark and b.serialno >= a.serialno ;
这条是mysql的写法
select concat(a.name, b.name) from tabTest a ,tabTest b where a.name != b.name and b.no >= a.no ;
*/
select concat(a.name, b.name) from tabTest a ,tabTest b where a.name != b.name and b.no >= a.no ;
id name
1 a
2 b
3 c
3 d
用一条sql 得出
ab
ac
ad
bc
bd
cdi
一下是oracle 的写法
insert into t1 values(1,'a');
insert into t1 values(2,'b');
insert into t1 values(3,'c');
insert into t1 values(3,'d');
select a.remark || b.remark from t1 a ,t1 b where a.remark <> b.remark and b.serialno >= a.serialno ;
这条是mysql的写法
select concat(a.name, b.name) from tabTest a ,tabTest b where a.name != b.name and b.no >= a.no ;
*/
select concat(a.name, b.name) from tabTest a ,tabTest b where a.name != b.name and b.no >= a.no ;