测试表建表及插入数据
create table TEST_TAB
(
CLO1 varchar(1),
COL2 varchar(1),
COL3 varchar(1)
);
insert into TEST_TAB values('1','b','c');
insert into TEST_TAB values('1','b','c');
insert into TEST_TAB values('2','b','c');
查看表中数据
删除重复的数据
DELETE FROM (select row_number() over(partition by CLO1,COL2,COL3 order by CLO1,COL2,COL3) AS ROW_NO FROM TEST_TAB )
WHERE ROW_NO>1
查看删除后的数据