摘要: oracle distinct 是所有字段都相同才显示一条,要做到根据某一列,则如下 select t1.* from table t1 where t1.rowid = (select min(t2.rowid) from table t2 where t1.c= t2.c) 阅读全文
posted @ 2018-09-29 15:35 walle1314 阅读(1193) 评论(0) 推荐(0) 编辑