Db2 Developer-C 11.1

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table test
(
  F1 char(5),
  F2 dec(7)
);
insert into test values
('00001', 1),
('00002', 2),
('00003', 3),
('00001', 4),
('00002', 5),
('00003', 6),
('00001', 7),
('00002', 8),
('00003', 9);
select * from test;                                       


F1
F2


00001
1

00002
2

00003
3

00001
4

00002
5

00003
6

00001
7

00002
8

00003
9


delete from
     (select rownumber() over(partition by F1 order by F1, F2)
       from test) AS E(RN)
where RN > 1
select * from test;


F1
F2


00001
1

00002
2

00003
3