wili grouping with rank

  
id
group_col
need_max
need_value

1
1
1
1
1

2
2
1
7
2

3
3
1
3
3

4
4
2
1
3

5
5
2
8
2

6
6
2
3
1


  
group_col
need_max

1
1
7

2
2
8


  
group_col
need_max
need_value

1
1
7
2

2
2
8
2


  
id
group_col
need_max
need_value
rnk

1
2
1
7
2
1

2
5
2
8
2
1