다른 정보는 필요없고 두 숫자 사이에 제일 큰 값만 조회하면 된다면 UNPIVOT를 사용해 보세요
with t as (
select 0 cola, 2 colb, 5 colc, 0 cold, 23 cole from dual union all
select 38 cola, 100 colb, 78 colc, 4 cold, 4 cole from dual union all
select 32 cola, 45 colb, 0 colc, 23 cold, 5 cole from dual union all
select 79 cola, 0 colb, 54 colc, 2 cold, 49 cole from dual
)
select max(num)
from t
UNPIVOT(
num
FOR nums
IN (cola,colb,colc,cold,cole)
)
where 1=1
and num between 23 and 60