Horton

Re: agregates

Eric B.Ridge <ebr@tcdi.com>

View thread View on postgr.es
From: Eric B.Ridge <ebr@tcdi.com>
To: Andrew Sullivan <andrew@libertyrms.info>
Cc: pgsql-general@postgresql.org
Date: 2003-01-22T22:15:44Z
Lists: pgsql-general 
On Wednesday, January 22, 2003, at 02:28  PM, Andrew Sullivan wrote:

> On Wed, Jan 22, 2003 at 10:07:06AM -0700, David Blood wrote:
>>
>> is there a better way to get the max - 1?
>
> You could try ORDER BY paymentid DESC LIMIT 1 OFFSET 1.  That'll give

wouldn't you want LIMIT 2 OFFSET 1 ?

eric