这是t_user表的表结构
create table T_USER
(USERID VARCHAR2(50) not null,
USERNAME VARCHAR2(50),
PASSWORD VARCHAR2(50)
)
1、上图是有关的数据,请删除表中重复的数据
delete from t_user t
where t.userid > any (select u.userid
from t_user u
where t.username = u.username
and t.password = t.password)
2、将t_user表里的数据插入到另一张表(chengji)里。
insert into chengji(name,kemu) select username,password from t_user