create table test( name varchar2(20), course char(20), score number)insert into test values('张三','语文',99);insert into test values('张三','数学',98);insert into test values('李四','语文',80);insert into test values('李四','数学',88);insert into test values('王五','语文',79);insert into test values('王五','数学',78)select a.name, sum(decode(a.course,'语文',a.score,null))as"语文", sum(decode(a.score,'数学',a.score,null))as"数学" from test a group by a.name order by a.name desc
--最后的展现结果是全都为空,请问各位大神哪儿出了毛病?顺路就给指点出来哈!谢谢了
--下面是错误的结果
--正确的应该是
注意哦,上面图片是错误的,下面是正确的!
é¦å ï¼ä½ ç¨çcharç±»åï¼ä¼èªå¨å¨ä½ å符串åè¾¹è¡¥ç©ºæ ¼ï¼æ以è¦ç¨trimå»ç©ºæ ¼
è¿æï¼ä½ 第äºä¸ªdecode,ä½ æ²¡åç°è·ä¸è¾¹ä¸ååï¼decodeæåé£ç¨0å§ï¼çå¾åºéï¼å«ç¨nullï¼ç¨è¿ä¸ªå§
select a.name,