TI_R_PRODUCTDATA_DOWN 表主键为(RECORDID,PRODUCTID),PRODUCTID字段有重复,要求只查询出相同PRODUCTID最新的一条:
红色部分是条件取最新的一条
SELECT A.PRODUCTID,A.MATERIALCODE,A.CUSTOMERTYPE,A.VENDORID,A.NAME,A.COLOR,A.INDATE,A.RECOMMENDPRICE,
A.MAXPRICE,A.PRODUCTIONSTATUS,A.PRODUCTSTATUS,A.PICTURETYPE,A.VERSIONS,A.PRODUCTPACKAGE,A.LOWEND,A.STEERFLAG,A.PILOTPRODUCT,'0','0'
FROM ucr_cen1.TI_R_PRODUCTDATA_DOWN A
WHERE A.RECORDID=(select max(D.RECORDID) from TI_R_PRODUCTDATA_DOWN B WHERE B.PRODUCTID = A.PRODUCTID )
附:查出productID有重复的记录
SELECT A.PRODUCTID FROM ucr_cen1.TI_R_PRODUCTDATA_DOWN A GROUP BY A.PRODUCTID having count(A.PRODUCTID)>1