H2 database 行相加-行列转换

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

H2 database 行相加-行列转换

原文：http://www.cnblogs.com/o-andy-o/p/3804555.html