Oracle 11g Release 2

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

CREATE TABLE tablename(SR int, H int, EAX_T int, EAI_T int);
INSERT ALL 
    INTO tablename (SR, H, EAX_T, EAI_T)
         VALUES (45, 8, -3, 0)
    INTO tablename (SR, H, EAX_T, EAI_T)
         VALUES (45, 8, -2, 0)
    INTO tablename (SR, H, EAX_T, EAI_T)
         VALUES (98, 8, 8, 0)
    INTO tablename (SR, H, EAX_T, EAI_T)
         VALUES (98, 8, 2, 0)
    INTO tablename (SR, H, EAX_T, EAI_T)
         VALUES (106, 8, 0, -1)
    INTO tablename (SR, H, EAX_T, EAI_T)
         VALUES (106, 8, 0, -9)
SELECT * FROM dual
;
6 rows affected

select * from tablename


SR
H
EAX_T
EAI_T


45
8
-3
0

45
8
-2
0

98
8
8
0

98
8
2
0

106
8
0
-1

106
8
0
-9


select distinct t.*
from (
  select t.sr, t.h,
    sign(eax_t) * max(abs(eax_t)) over (partition by sr, h) eax_t,
    sign(eai_t) * max(abs(eai_t)) over (partition by sr, h) eai_t
  from tablename t
) t
order by t.sr, t.h


SR
H
EAX_T
EAI_T


45
8
-3
0

98
8
8
0

106
8
0
-9