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;

posted @ 2014-03-07 11:14  醉洒脱  阅读(2023)  评论(0编辑  收藏  举报