oracle 数据重复，只取一条oracle中重复记录只取其中一条select * from table1 where rowidany(select max
oracle 数据重复，只取一条
oracle中重复记录只取其中一条select * from table1 where rowid=any(select max(rowid) from table1 group by field1)或者select * from table1 where rowid in (select max(rowid) from table1 group by field1)
