帮忙简化SQL oracle用varchar2(4000)储存

select trim(a.taskno) taskno,
(select QR540 from prj_wlw where taskno=a.taskno and WORKPROP='1' and worktype='1') QR540,(select QR540 from prj_wlw where taskno=a.taskno and WORKPROP='1' and worktype='2') QR540,
(select QR540 from prj_wlw where taskno=a.taskno and WORKPROP='2' and worktype='1') QR540,(select QR540 from prj_wlw where taskno=a.taskno and WORKPROP='2' and worktype='2') QR540,
(select QR540 from prj_wlw where taskno=a.taskno and WORKPROP='3' and worktype='1') QR540,(select QR540 from prj_wlw where taskno=a.taskno and WORKPROP='3'and worktype='2') QR540,
(select RAYLEN from prj_wlw where taskno=a.taskno and WORKPROP='1' and worktype='1') RAYLEN,(select RAYLEN from prj_wlw where taskno=a.taskno and WORKPROP='1' and worktype='2') RAYLEN,
(select RAYLEN from prj_wlw where taskno=a.taskno and WORKPROP='2' and worktype='1') RAYLEN,(select RAYLEN from prj_wlw where taskno=a.taskno and WORKPROP='2' and worktype='2') RAYLEN,
(select RAYLEN from prj_wlw where taskno=a.taskno and WORKPROP='3' and worktype='1') RAYLEN,(select RAYLEN from prj_wlw where taskno=a.taskno and WORKPROP='3'and worktype='2') RAYLEN,
(select WIRELEN from prj_wlw where taskno=a.taskno and WORKPROP='1' and worktype='1') WIRELEN,(select WIRELEN from prj_wlw where taskno=a.taskno and WORKPROP='1' and worktype='2') WIRELEN,
(select WIRELEN from prj_wlw where taskno=a.taskno and WORKPROP='2' and worktype='1') WIRELEN,(select WIRELEN from prj_wlw where taskno=a.taskno and WORKPROP='2' and worktype='2') WIRELEN,
(select WIRELEN from prj_wlw where taskno=a.taskno and WORKPROP='3' and worktype='1') WIRELEN,(select WIRELEN from prj_wlw where taskno=a.taskno and WORKPROP='3'and worktype='2') WIRELEN,
(select TWIST from prj_wlw where taskno=a.taskno and WORKPROP='1' and worktype='1') TWIST,(select TWIST from prj_wlw where taskno=a.taskno and WORKPROP='1' and worktype='2') TWIST,
(select TWIST from prj_wlw where taskno=a.taskno and WORKPROP='2' and worktype='1') TWIST,(select TWIST from prj_wlw where taskno=a.taskno and WORKPROP='2' and worktype='2') TWIST,
(select TWIST from prj_wlw where taskno=a.taskno and WORKPROP='3' and worktype='1') TWIST,(select TWIST from prj_wlw where taskno=a.taskno and WORKPROP='3'and worktype='2') TWIST,
(select REPEATCABLE from prj_wlw where taskno=a.taskno and WORKPROP='1' and worktype='1') REPEATCABLE,(select REPEATCABLE from prj_wlw where taskno=a.taskno and WORKPROP='1' and worktype='2') REPEATCABLE,
(select REPEATCABLE from prj_wlw where taskno=a.taskno and WORKPROP='2' and worktype='1') REPEATCABLE,(select REPEATCABLE from prj_wlw where taskno=a.taskno and WORKPROP='2' and worktype='2') REPEATCABLE,
(select REPEATCABLE from prj_wlw where taskno=a.taskno and WORKPROP='3' and worktype='1') REPEATCABLE,(select REPEATCABLE from prj_wlw where taskno=a.taskno and WORKPROP='3'and worktype='2') REPEATCABLE,
from (select distinct taskno from prj_wlw) a order by a.taskno desc

Csdn user default icon
上传中...
上传图片
插入图片
抄袭、复制答案,以达到刷声望分或其他目的的行为,在CSDN问答是严格禁止的,一经发现立刻封号。是时候展现真正的技术了!
立即提问
相关内容推荐