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 special case of max/min, you can use things like ORDER BY/LIMIT to acheive the effect you want. And DISTINCT ON () is also useful in such situations. -- 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
