oracle中去除重复的,oracle中sql去除重复数据

--建表

create table t_user( id NUMBER not null ,

user_id NUMBER,

user_name varchar(100),

primary key(id)

)

--入数据

insert into t_user values(1,1,'admin');

insert into t_user values(2,1,'admin');

insert into t_user values(3,2,'superadmin');

insert into t_user values(4,2,'superadmin');

insert into t_user values(5,3,'auditadmin');

--正题sql

--方式一

delete from t_user where id not in (

select min(id) id from t_user group by user_id order by id

)

--方式二 row_number

select id,user_id,user_name

from(

(select id,user_id,user_name,row_number() over(partition by user_id order by user_id desc) rn from t_user )

) where rn=1

--参考：