Finding number withing specific range

I have a requirement where I need to check the lower and higher "range" for specific number

Example:

Range:

0.05
0.1
0.15
0.2
0.25
0.3
0.35

So if I am provided with number say 0.29, I have to return below outout

Number      Low_range         High_range
0.29            0.2                      0.3
0.13            0.1                      0.15

How can I do this via oracle sql? I tried couple of options but nothing seems to work.

Any help would be appreciated Received on Tue Apr 23 2013 - 23:23:36 CEST