oracle distinct 去除重复,同时按某字段排序

SELECT distinct supplier_id, min(evidence_date) as evidence_date FROM TD_SUPPLIER_EVIDENCE_INFO where VERIFIER = 'gaoyinghui' group by supplier_id order by evidence_date desc;

原文地址:https://www.cnblogs.com/gaoyinghui/p/3586011.html