SELECT MATERIALNAME,ITEM_NAME,PRODUCT_LV2_CLASS,TEST_DESC,HDL_VALUE,CASE WHEN RESULT='1' THEN '是' ELSE '否' END RESULT FROM ADS_LIMS_PRODUCT_QUALIFICATION WHERE 1=1 ${IF(ty='供应商',"","AND ITEM_NAME = '"+ty+"'")} AND TO_CHAR(REPORTDATE, 'YYYY') = SUBSTR('${P_S_DATE}',1,4)ORDER BY MATERIALNAME,TEST_DESC想根据参数TY是否为供应商来隐藏ITEM_NAME,PRODUCT_LV2_CLASS,这两个字段的展示,但因为SQL里面有这两个字段,那些隐藏着两个字段的展示会出现重复数据