Hello
select min(x) from (select x from data order by x desc limit 2) s;
Pavel
2010/3/4 Louis-David Mitterrand <vindex+lists-pgsql-sql(at)apartia(dot)org>:
> Hi,
>
> With builtin aggregates is it possible to return the value just before
> max(col)?
>
> Thanks,
>
> --
> Sent via pgsql-sql mailing list (pgsql-sql(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-sql
>