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