RE: [sqlite] SQL help

[Tim McDaniel]

Dennis Cote came up with this, which I think will work...

select t.* from t join (select max(a) as a, b from t group by b) as key
where t.a=key.a and t.b=key.b;

Thanks for all the suggestions.
Tim