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;