Oracle单表去重
create table A_TEST (id number,
name varchar2(20),
remark varchar2(20)
);
insert into A_TEST (ID, NAME, REMARK)
values (1, 'a', 'ss');
insert into A_TEST (ID, NAME, REMARK)
values (2, 'b', 'xxx');
insert into A_TEST (ID, NAME, REMARK)
values (3, 'b', 'x');
insert into A_TEST (ID, NAME, REMARK)
values (4, 'b', 'asd');
insert into A_TEST (ID, NAME, REMARK)
values (5, 'c', 'axxx');
insert into A_TEST (ID, NAME, REMARK)
values (6, 'c', 'asdf');
页:
[1]