Oracle数据重复，只取一条
时间：2021-07-01 10:21:17
帮助过：5人阅读
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
