Finding number withing specific range

From: Pankaj <harpreet.noni_at_gmail.com>
Date: Tue, 23 Apr 2013 14:31:18 -0700 (PDT)
Message-ID: <2f9bb59a-e348-4506-9379-12c6137e848b_at_e13g2000vbn.googlegroups.com>

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:31:18 CEST