第一种方法:
查询表:SELECT * FROM pub_systemplate_base WHERE upper ( funnode ) = upper ( 'Z2010203' ) ORDER BY tempstyle
将nodekey这个字段的值置位空
如上还不行:
查询表:select * from pub_systemplate where pk_corp='0001AZ100000000001NY' and funnode='Z2010203' and nodekey = 'qt' order by ts desc
查看数据是否唯一