Re: [SQL] an aggregate to return max() - 1 value?

[Rob Sargent]

'select max(col) where col < max(col)' should work but you have to do 
'where col < (select max(col) '

On 03/04/2010 01:09 PM, Louis-David Mitterrand wrote:
Hi,
With builtin aggregates is it possible to return the value just before
max(col)?

Thanks,


--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql