On Wed, Feb 28, 2007 at 04:57:08PM -0800, Omar Eljumaily wrote: > OK, I see what's going on. I can have more than one max(amount) with > the same amount and payee. Thanks so much. Like I said, it's sort of > dogged me off and on many times. Note that in the case of min/max you can use ORDER BY/LIMIT or DISTINCT ON () to acheive the effect you want. Have a nice day, -- Martijn van Oosterhout <kleptog@xxxxxxxxx> http://svana.org/kleptog/ > From each according to his ability. To each according to his ability to litigate.
Attachment:
signature.asc
Description: Digital signature