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;