æå¨oracleéç®ååäºä¸ä¸ªï¼æ°æ®æ²¡ç¨ä½ çï¼å½è¿å»å¥½éº»ç¦
ä½ ç®åçä¸æ¯æä¹å¤çç
建表åæå
¥æ°æ®
create table t(å»é¢ç§å®¤ç¼ç varchar(20),
è¯åå varchar(20),
æ»éé¢ int);
insert into t values ('A','aaa',100);
insert into t values ('A','bbb',200);
insert into t values ('A','ccc',300);
insert into t values ('B','ddd',24);
insert into t values ('B','eee',46);
insert into t values ('B','fff',68);
insert into t values ('C','ggg',22);
insert into t values ('C','hhh',13);
insert into t values ('C','iii',67);
æ§è¡
select a.* from
(select * from t
union all
select å»é¢ç§å®¤ç¼ç ||'å计','',sum(æ»éé¢) æ»éé¢ from t group by å»é¢ç§å®¤ç¼ç ) a
order by substr(å»é¢ç§å®¤ç¼ç ,1,1),length(å»é¢ç§å®¤ç¼ç )
ç»ææªå¾
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/b2de9c82d158ccbfdac072c718d8bc3eb03541cb?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
ä¼°è®¡ä½ ååºæ¥è¯å®ä¼åå¨è¿æ ·æé£æ ·çé®é¢ï¼hiææè
æ
追é®è¦çå°±æ¯è¿æ ·çç»æä½æ¯æåçè¯å¥å¥½åæé®é¢ï¼æ天麻ç¦å¸®æçä¸ä¸ãããã谢谢ï¼ï¼
追çè¿ä¼è¦åºé¨äºï¼ä¸ç¥éä½ ç¨çä»ä¹æ°æ®åºï¼ä¸å估计4ç¹åå¨çº¿ï¼æé®é¢çè¨å§