2014年3月7日
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 醉洒脱 阅读(2024) 评论(0) 推荐(0) 编辑