--完全相同的数据去掉重复
select id,orderId
from (
select row_number()
over(
order by id) rowId,
* from v_order)
as tt
where rowId
in
(
select min(rowId)
from (
select row_number()
over(
order by id) rowId,
* from v_order) bb
group by id
having count(id)
>=1
)
转载于:https://www.cnblogs.com/daixingqing/archive/2012/11/13/2768394.html
相关资源：ORACLE PL/SQL去重语句详解
