CSDN博客

img faintbear

oracle decode 应用

发表于2004/9/29 16:59:00  1300人阅读

分类: 学习笔记

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
阅读全文
0 0

相关文章推荐

img
取 消
img