MySQL 8.0

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

create table Test(id1 integer, id2 integer);
create table tb11(id1 integer, id2 integer);
create table tb12(id1 integer, id2 integer);
insert into Test(id1, id2) values(1, 10);
insert into Test(id1, id2) values(1, 20);
insert into Test(id1, id2) values(2, 10);
insert into Test(id1, id2) values(2, 20);
INSERT INTO tb11  
SELECT id1, id2 FROM  
(SELECT
    id1,
    id2,
    RANK() OVER (PARTITION BY id2 ORDER BY id1 ASC) as rnk
FROM
    Test) t1 where t1.rnk = 1;
INSERT INTO tb12  
SELECT id1, id2 FROM  
(SELECT
    id1,
    id2,
    RANK() OVER (PARTITION BY id2 ORDER BY id1 ASC) as rnk
FROM
    Test) t2  where t2.rnk = 2;
SELECT * FROM tb11;
SELECT * FROM tb12;


id1
id2


1
10

1
20




id1
id2


2
10

2
20