17,086
社区成员
发帖
与我相关
我的任务
分享
select
'SELECT TYPE,'||
WMSYS.WM_CONCAT('MAX(DECODE(NAME,'''||NAME||''',VALUE) as 单位'||ROWNUM)
||'
FROM(
select name,''受理数'' as type,受理数 AS VALUE from T
UNION ALL
select name,''办结数'' as type,办结数 AS VALUE from T
UNION ALL
select name,''超期数'' as type,超期数 AS VALUE from T)
GROUP BY TYPE' from T
SELECT TYPE,
MAX(DECODE(NAME,'单位1',VALUE) as 单位1,
MAX(DECODE(NAME,'单位2',VALUE) as 单位2,
MAX(DECODE(NAME,'单位3',VALUE) as 单位3,
……
……
FROM(
select name,'受理数' as type,受理数 AS VALUE from T
UNION ALL
select name,'办结数' as type,办结数 AS VALUE from T
UNION ALL
select name,'超期数' as type,超期数 AS VALUE from T)
GROUP BY TYPE