H2 database 行相加-行列转换
时间：2022-03-10 17:44
create or replace view view_acceptCompany
as
select * from (select WARNIGID,
max(CASEWHEN(zhtablename=‘中文表名‘, ‘中文表名‘, null)) field1,
max(CASEWHEN(zhtablename=‘管控类型‘, ‘管控类型‘, null)) field2,
max(CASEWHEN(zhtablename=‘测试中文表名‘, ‘测试中文表名‘, null)) field3 ,
max(CASEWHEN(zhtablename=‘测试中文表名2222‘, ‘测试中文表名2222‘, null)) field4
from monitor group by WARNIGID) as v_acceptCompany;
H2 database 行相加-行列转换,布布扣,bubuko.com
