SELECT 'HJT-0623-ys' AS 要素, SUM(DECODE(模块,'勘探',数量)) AS "勘探", SUM(DECODE(模块,'炼化',数量)) AS "炼化", SUM(DECODE(模块,'销售',数量)) AS "销售", SUM(DECODE(模块,'管道',数量))AS "管道", SUM(DECODE(模块,'科研',数量)) AS "科研", SUM(DECODE(模块,'工技',数量)) AS "工技", SUM(DECODE(模块,'工建',数量)) AS "工建", SUM(DECODE(模块,'装备',数量)) AS "装备", SUM(DECODE(模块,'其他',数量)) AS "其他", SUM(DECODE(模块,'海外',数量)) AS "海外", SUM(DECODE(模块,'222',数量)) AS "222", SUM(DECODE(模块,'1231',数量)) AS "1231" FROM T GROUP BY 'HJT-0623-ys'
SUM(DECODE(模块,'勘探',数量)) AS "勘探",
SUM(DECODE(模块,'炼化',数量)) AS "炼化",
SUM(DECODE(模块,'销售',数量)) AS "销售",
SUM(DECODE(模块,'管道',数量))AS "管道",
SUM(DECODE(模块,'科研',数量)) AS "科研",
SUM(DECODE(模块,'工技',数量)) AS "工技",
SUM(DECODE(模块,'工建',数量)) AS "工建",
SUM(DECODE(模块,'装备',数量)) AS "装备",
SUM(DECODE(模块,'其他',数量)) AS "其他",
SUM(DECODE(模块,'海外',数量)) AS "海外",
SUM(DECODE(模块,'222',数量)) AS "222",
SUM(DECODE(模块,'1231',数量)) AS "1231"
FROM T
GROUP BY 'HJT-0623-ys'