Oracle 21c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table team (position, name, height) as
select 'GK', 'Jhon', 178 from dual union all
select 'GK', 'Steven', 190 from dual union all
select 'DF', 'Paul', 183 from dual union all
select 'DF', 'Andrew', 178 from dual union all
select 'DF', 'Nick', 169 from dual union all
select 'MF', 'Ali', 170 from dual union all
select 'MF', 'Peter', 176 from dual union all
select 'MF', 'Charlie', 180 from dual union all
select 'FW', 'Simon', 185 from dual union all
select 'FW', 'Son', 184 from dual union all
select 'FW', 'Jack', 179 from dual
11 rows affected

SELECT POSITION, MAX(HEIGHT) FROM TEAM GROUP BY POSITION; 


POSITION
MAX(HEIGHT)


GK
190

DF
183

MF
180

FW
185


SELECT POSITION,
  MAX(NAME) KEEP (DENSE_RANK LAST ORDER BY HEIGHT) AS NAME,
  MAX(HEIGHT) AS HEIGHT
FROM TEAM
GROUP BY POSITION; 


POSITION
NAME
HEIGHT


DF
Paul
183

FW
Simon
185

GK
Steven
190

MF
Charlie
180