Oracle数据重复，只取一条

select * from tb_supply where rowid=any(select max(rowid) from tb_supply group by phone_id) --方法二 select * from tb_supply where rowid in (select max(rowid) from tb_supply group by phone_id)

 

Oracle数据重复，只取一条

标签：any   oracle   hone   ora   bsp   phone   方法   nbsp   one