AND
s.IS_MGD = ‘1’
s.IS_FOCUS = ‘1’
decode(s.SHEET_ID,null,‘null’,‘is_sheet’)= ‘is_sheet’
s.RN= 1
s.yydxdata_cc like ‘%’ || ‘实际异常’ || ‘%’
s.yydxdata_cc like ‘%’ || ‘核实中’ || ‘%’
mybatis中多个字段都用in或者=号
于 2023-12-01 16:12:25 首次发布
AND
s.IS_MGD = ‘1’
s.IS_FOCUS = ‘1’
decode(s.SHEET_ID,null,‘null’,‘is_sheet’)= ‘is_sheet’
s.RN= 1
s.yydxdata_cc like ‘%’ || ‘实际异常’ || ‘%’
s.yydxdata_cc like ‘%’ || ‘核实中’ || ‘%’