ORACLE-只针对某列去重(无PK)
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 PDLINE...
原创
2019-12-05 11:56:19 ·
596 阅读 ·
0 评论