iA25CdiS

1drop table if exists duplicates;
2
3create table duplicates
4(
5id int not null primary key,
6code int not null
7);
8
9insert into duplicates (id, code) values (1,1),(2,1),(3,2),(4,2),(5,2),(6,3),(7,4),(8,5),(9,5),(10,5),(11,6),(12,7),(13,7), (14,7);
10
11select * from duplicates;
12
13drop table if exists foo;
14
15create table foo 
16select
17 max(id) as id,
18 code
19from
20 duplicates
21group by
22 code;
23
24select * from foo;
25
26truncate table duplicates;
27
28insert into duplicates select * from foo;
29
30select * from duplicates;