zt-委外核价单.zip上面供应商:DYJJ001 只想显示最近日期的数据 需要怎么设置 请大神们指教一下SELECT pmdidocdt as 制单日期, PMDI004 AS 供应商编号,pmdj002 as 料号,imaal003 as 品名,imaal004 AS 规格,pmdj011 as 单价,pmaal004 as 供应商全称,(case when pmdisite='DL'then'德利福' when pmdisite='DY'then'德远' else '' end)as 据点FROM PMDI_Tleft join pmdj_t on pmdjdocno=pmdidocno and pmdjent=pmdient and pmdjsite=pmdisiteleft join imaal_t on imaal001=pmdj002 and imaalent=pmdjent and imaal002='zh_CN'left join pmaal_t on pmaal001=pmdi004 and pmaalent=pmdient and pmaal002='zh_CN'WHERE PMDIENT='18'${if(len(规格)=0,"","and imaal004='"+规格+"'")}${if(len(料号)=0,"","and pmdj002='"+料号+"'")}and pmdistus<>'X'and (PMDI004='WG0017' or PMDI004='WG1175' or PMDI004='WG0027'or PMDI004='WG1178' or PMDI004='WG1118' or PMDI004='WG1172' or PMDI004='WG1069' or PMDI004='WG1171')以上代码 PMDI004='WG0017' or PMDI004='WG1175' or PMDI004='WG0027'or PMDI004='WG1178' or PMDI004='WG1118' or PMDI004='WG1172' or PMDI004='WG1069' or PMDI004='WG1171' 这些是需要筛选的供应商实现的目标是 筛选后的数据 只显示以上供应商 最近日期的一笔数据 这个需要如何实现