Re: an aggregate to return max() - 1 value?
От
Rob Sargent
Тема
Re: an aggregate to return max() - 1 value?
Дата
Msg-id
4B901607.2090409@gmail.com
Ответ на
an aggregate to return max() - 1 value? (Louis-David Mitterrand)
Список
Дерево обсуждения
an aggregate to return max() - 1 value? Louis-David Mitterrand <vindex+lists-pgsql-sql@apartia.org>
Re: an aggregate to return max() - 1 value? Pavel Stehule <pavel.stehule@gmail.com>
Re: an aggregate to return max() - 1 value? Gerardo Herzig <gherzig@fmed.uba.ar>
Re: an aggregate to return max() - 1 value? Greg Stark <gsstark@mit.edu>
Re: an aggregate to return max() - 1 value? Louis-David Mitterrand <vindex+lists-pgsql-sql@apartia.org>
Re: an aggregate to return max() - 1 value? Rob Sargent <robjsargent@gmail.com>
'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, >
В списке pgsql-sql по дате отправления
