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 行相加-行列转换
最新推荐文章于 2022-11-09 14:22:18 发布