with T AS (你的查询语句) select '总数' as name, MAX(decode(企业,'炼化',总数)) as 炼化, MAX(decode(企业,'装备',总数)) as 装备, …… from T union all select '未注册' as name, MAX(decode(企业,'炼化',未注册)) as 炼化, MAX(decode(企业,'装备',未注册)) as 装备, …… from T union all select '注册率' as name, MAX(decode(企业,'炼化',注册率)) as 炼化, MAX(decode(企业,'装备',注册率)) as 装备, …… from T
select '总数' as name,
MAX(decode(企业,'炼化',总数)) as 炼化,
MAX(decode(企业,'装备',总数)) as 装备,
……
from T
union all
select '未注册' as name,
MAX(decode(企业,'炼化',未注册)) as 炼化,
MAX(decode(企业,'装备',未注册)) as 装备,
……
from T
union all
select '注册率' as name,
MAX(decode(企业,'炼化',注册率)) as 炼化,
MAX(decode(企业,'装备',注册率)) as 装备,
……
from T