select discount
from tablename
where x between lowerrange and upperrange
union all
select max(discount) from tablename
where not exists (
  select 1 from tablename
  where x between lowerrange and upperrange
)