Re: [sqlite] Finding max of each group?

Thanks for the advice, guys. After fiddling around with it a bit, I went for the age-old solution of changing the data and the requirements so it wasn't necessary :) Thanks, Colin On 10/08/05, Kurt Welgehausen <[EMAIL PROTECTED]> wrote: > > select conversation_id, count(*), max(unread),

[sqlite] Finding max of each group?

I'm writing a messaging system, and I have the following problem. I have a conversations table, and a messages table that has a foreign key to conversations. I can do something like the following to provide a summary: select conversation_id, count(*), max(unread), max(updated_on) from messages