Re: [sqlite] find the highest rank per group

On 1/28/08, Fowler, Jeff <[EMAIL PROTECTED]> wrote: > Puneet, > > I'm assuming you meant to say "where rank is the highest" rather than > title, as that's what your example shows. indeed. > > Here's the syntax: > select * from table a > where rank = (select max(rank) from table b where b.id =

RE: [sqlite] find the highest rank per group

Puneet, I'm assuming you meant to say "where rank is the highest" rather than title, as that's what your example shows. Here's the syntax: select * from table a where rank = (select max(rank) from table b where b.id = a.id) - Jeff -Original Message- From: P Kishor [mailto:[EMAIL