SELECT MA.PDLINEGROUP,MA.CREATEDATE,MA.CREATER,MA.PRODUCTCATEGORY
FROM TBLPQMPDLINEGROUP MA
INNER JOIN (
SELECT DISTINCT M.PDLINEGROUP, G.CREATEDATE FROM TBLPQMPDLINEGROUP M
LEFT JOIN (
SELECT PDLINEGROUP, PRODUCTCATEGORY,MAX(CREATEDATE) CREATEDATE FROM TBLPQMPDLINEGROUP
GROUP BY PDLINEGROUP,PRODUCTCATEGORY) G ON M.PDLINEGROUP=G.PDLINEGROUP
) O ON O.PDLINEGROUP=MA.PDLINEGROUP AND O.CREATEDATE=MA.CREATEDATE
ORACLE-只针对某列去重(无PK)
最新推荐文章于 2023-05-04 11:41:48 发布