高分求SQL

Question

table:sfc_wip內容如下：
part       date1             date2           codeno    pcnum 
531 2007/07/23 2007/07/08 010 80
531 2007/07/23 2007/07/08 311 11
531 2007/07/23 2007/07/08 320 12
531 2007/07/23 2007/07/08 312 23
531 2007/07/23 2007/07/08 220 14得到如下結果
part         date1           date2        010        311     320     312    220
531 2007/07/23 2007/07/08    80           11       12        23       14

Answer 1

http://atgc.itpub.net/post/22412/251110

Answer 2

如果codeno是固定的几个值则:
select part,dete1,date2,
max(decode(codeno,'010',pcnum,'')),
max(decode(codeno,'311',pcnum,'')),
max(decode(codeno,'320',pcnum,'')),
max(decode(codeno,'312',pcnum,'')),
max(decode(codeno,'220',pcnum,''))
from sfc_wip
group by part,date1,date2
否则需要想将codeno的值求出来,然后动态生成sql