[thelist] SQL Query

[Jack Timmons]

On Tue, Jun 8, 2010 at 12:06 PM, Christopher Marsh
<Christopher.Marsh at akqa.com> wrote:
> Would the following satisfy your criteria?
>
> SELECT MAX(paid_on),
> id
> FROM charges
> GROUP BY id

It does for the explanation I gave, except I missed out a vital part
that you'd have only figured out if you could see through the blood in
your eyes after looking at my query.

Each charge has a related amount. I need the most recent charge,
because I have to perform logic against the amount back.

-- 
-Jack Timmons
Blog: http://www.codeacula.com
Sandbox: http://www.trotlc.com
Twitter: @codeacula
Google Chat: Figure it out. C'mon, seriously.