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)  

 

posted @ 2018-12-01 10:29  沙耶  阅读(2754)  评论(0编辑  收藏  举报