sql - SQL 如何修改这张表

Question

如何在sql中获取此表：

id   cunsumption_bhd cunsumption_metha 
id1  21.0            10.2

从此表中：

id   type   cunsumption
id1  bhd    21.0
id1  metha  10.2

标签： sql

Answer 1

一种方法是条件聚合：

select max(case when type = 'bhd' then consumption end) as consumption_bhd,
       max(case when type = 'metha' then consumption end) as consumption_metha
from t;