--方法一 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数据重复，只取一条
原文：https://www.cnblogs.com/ShaYeBlog/p/10048562.html
