select c3,sum(c1),(select c2 from test1 a where a.c3=test1.c3 and rownum=1) from test1 group by c3;
如果是在sqlplus中执行,这样写
select c3,sum(c1),utl_raw.cast_to_varchar2((select c2 from test1 a where a.c3=test1.c3 and rownum=1)) from test1 group by c3;
如果是在sqlplus中执行,这样写
select c3,sum(c1),utl_raw.cast_to_varchar2((select c2 from test1 a where a.c3=test1.c3 and rownum=1)) from test1 group by c3;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货