Re: getting the nearest number from a column

On 10 avr, 18:39, Mladen Gogala <mgogala.SPAM-ME...._at_verizon.net> wrote:
> On Tue, 10 Apr 2007 08:56:06 -0700, hasta_l3 wrote:
> > Would you mean a bug in Oracle (documentation), Mladen ?
>
> > Granted, this area is somewhat tricky, but I don't see a bug here, for
> > my understanding is :
>
> > - RANK is a ranking function, that is computed for the whole
> > group/partition
>
> Find me a mention that this is a windowing function:http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14200/
> functions087.htm#i1280029
>

Well, MIN is so classified in the database warehousing guide :

  http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14223/analysis.htm#i1014372

The windowing behavior is demonstrated in the analytic example of the page you refer to above

• Raoul