Re: getting the nearest number from a column

On Tue, 10 Apr 2007 12:34:40 -0700, hasta_l3 wrote:

> Mladen, I agree that one may be surprised by the behavior of MIN, and I
> agree that the documentation could be improved, to say the least.
>
> However, I do not agree that there is a documentation bug stricto sensu,
> for
> the reference of MIN explicitly requests to look at "Analytic Functions"
> for
> semantic, which in turns requests to look at the database warehouse
> guide.

Raul, I must say it again: that is only my opinion. While the row_number() and rank() tricks will work for the MIN function, they will not work for the max() function. To do that, you will have to order by desc.

-- 
http://www.mladen-gogala.com