select yw_seq,sum(bill),sum(louisa),sum(lynn),sum(wang),com_no from (select com_no,yw_seq,decode(person,'0001',(agree)) as lynn,decode(person,'0011',(agree)) as bill,decode(person,'0054',(agree))as wang,decode(person,'0005',(agree)) as louisa from ywht_shenpi group by yw_seq,person,agree,com_no) group by yw_seq,com_no
版權(quán)聲明：CSDN是本Blog托管服務(wù)提供商。如本文牽涉版權(quán)問題，CSDN不承擔(dān)相關(guān)責(zé)任，請版權(quán)擁有者直接與文章作者聯(lián)系解決。