oracle distinct 是所有字段都相同才显示一条,要做到根据某一列,则如下
select t1.* from table t1 where t1.rowid = (
select min(t2.rowid) from table t2 where t1.c= t2.c
)
oracle distinct 是所有字段都相同才显示一条,要做到根据某一列,则如下
select t1.* from table t1 where t1.rowid = (
select min(t2.rowid) from table t2 where t1.c= t2.c
)
转载于:https://www.cnblogs.com/zsqfightyourway/p/9723982.html