sql合并数据表,有多条变成一条 若不清楚,可http://zhidao.baidu.com/question/427405338.html?quesup2&oldq=1 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 create table t1(id int ,name varchar(20),c1 varchar(20),c2 varchar(20),c3 varchar(20) );insert into t1 values (1,'wc','as','','');insert into t1 values (2,'wc','asd','','');insert into t1 values (3,'wc','','fdf','');insert into t1 values (4,'wc','','','er');insert into t1 values (5,'wd','fg','','');insert into t1 values (6,'wd','fgo','','');insert into t1 values (7 ,'wd','','ko',''); commit;select name, substr(c1,instr(c1,',',-1)+1,length(c1)) c1, substr(c2,instr(c2,',',-1)+1,length(c2)) c2, substr(c3,instr(c3,',',-1)+1,length(c3)) c3from (select name, wm_concat(c1) c1, wm_concat(c2) c2, wm_concat(c3) c3 from t1 group by name) name c1 c2 c3----------------------------------------1 wc asd fdf er2 wd fgo ko select * from (select id ,name,c1,c2 ,c3,rownumber over (partition by id desc )rn from t1)a where a.rn=1 批量UPDATE两个表中的数据. 如何调用返回不定字段个数的存储过程 求助各路朋友指点一下一段sql语法问题 sql脚本导入oracle 求sql语句 请教一个random的问题,谢谢。 如何取得oracle的当前系统时间 对于数据库中越来越多的归档日志有啥好的处理办法,是否删除了归档日志就会影响数据库以后的恢复 [讨论]oracle的安装方法与cpu有关系吗?(回复都有分) OracleOraHome81ManagementServer的启动问题。 Oracle自增长溢出求解 mysql存储过程转为oracle存储过程
create table t1(id int ,name varchar(20),c1 varchar(20),c2 varchar(20),c3 varchar(20) );insert into t1 values (1,'wc','as','','');
insert into t1 values (2,'wc','asd','','');
insert into t1 values (3,'wc','','fdf','');
insert into t1 values (4,'wc','','','er');
insert into t1 values (5,'wd','fg','','');
insert into t1 values (6,'wd','fgo','','');
insert into t1 values (7 ,'wd','','ko','');
commit;select name,
substr(c1,instr(c1,',',-1)+1,length(c1)) c1,
substr(c2,instr(c2,',',-1)+1,length(c2)) c2,
substr(c3,instr(c3,',',-1)+1,length(c3)) c3
from (select name,
wm_concat(c1) c1,
wm_concat(c2) c2,
wm_concat(c3) c3
from t1
group by name)
name c1 c2 c3
----------------------------------------
1 wc asd fdf er
2 wd fgo ko