MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE IF NOT EXISTS `example` (
  id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
  `col1` INT(6) NOT NULL,
  `col2` int(10) unsigned NOT NULL
);
INSERT INTO `example` (`col1`, `col2`) VALUES
  ('1', '1'),
  ('3', '1'),
  ('11', '10'),
  ('12', '10'),
  ('15', '1'),
  ('20', '10'),
  ('21', '1'),
  ('22', '20'),
  ('22', '10'),
  ('25', '20'),
  ('26', '10');
SELECT col1,col2 FROM example;

Records: 11  Duplicates: 0  Warnings: 0




col1
col2


1
1

3
1

11
10

12
10

15
1

20
10

21
1

22
20

22
10

25
20

26
10


CREATE TABLE IF NOT EXISTS `result` (
  id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
  `col1` INT(6) NOT NULL,
  `col2` int(10) unsigned NOT NULL
);
INSERT INTO `result` (`col1`, `col2`) VALUES
  ('1', '1'),
  ('3', '1'),
  ('11', '10'),
  ('12', '10'),
  ('15', '10'),
  ('20', '10'),
  ('21', '10'),
  ('22', '10'),
  ('22', '20'),
  ('25', '20'),
  ('26', '20');
SELECT col1,col2 FROM result;

Records: 11  Duplicates: 0  Warnings: 0




col1
col2


1
1

3
1

11
10

12
10

15
10

20
10

21
10

22
10

22
20

25
20

26
20


SELECT col1,
       MAX(col2) OVER (ORDER BY col1) col2
FROM example
ORDER BY col1


col1
col2


1
1

3
1

11
10

12
10

15
10

20
10

21
10

22
20

22
20

25
20

26
20