MySQL 8.0

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

create table test(id int, low int, high int)
insert into test values(1, 3, 10)
insert into test values(1, 2, 09)
insert into test values(1, 11, 14)
insert into test values(2, 3, 10)
select id, low, high,
DENSE_RANK() over (partition by id order by id, res desc) as tag
from
(select id, low, high, (high-low) as res
from test) a


id
low
high
tag


1
3
10
1

1
2
9
1

1
11
14
2

2
3
10
1