oracle去除重复数据常用的方法

SELECT *  from ecm_query t
where t.rowid   in  (
select rid
                     from (select t1.rowid rid,
                                  row_number() over(partition by t1.id, t1.name order by 1) rn
                             from ecm_query t1) t1
                    where t1.rn > 1)
                   
select t1.rowid rid, row_number() over(partition by t1.id, t1.name order by 1) rn                                
from ecm_query t1 WHERE id ='e56d2f1105794294979189f8073d5699' 

https://blog.csdn.net/nayi_224/article/details/82020913