Re: Finding number withing specific range
From: ddf <oratune_at_msn.com>
Date: Thu, 25 Apr 2013 05:56:29 -0700 (PDT)
Message-ID: <929eaa69-1e7d-4b86-bee1-76dcef05edb4_at_googlegroups.com>
On Tuesday, April 23, 2013 3:31:18 PM UTC-6, Pankaj wrote:
> 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
Date: Thu, 25 Apr 2013 05:56:29 -0700 (PDT)
Message-ID: <929eaa69-1e7d-4b86-bee1-76dcef05edb4_at_googlegroups.com>
On Tuesday, April 23, 2013 3:31:18 PM UTC-6, Pankaj wrote:
> 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
You're getting help, you're simply not getting the work done for you. Posting to another group won't likely get you any further as the same people monitor all of the comp.databases.oracle newsgroups.
Post what you've done and we'll assist -- we won't do the work for you.
David Fitzjarrell Received on Thu Apr 25 2013 - 14:56:29 CEST