> I want the title, the MAX(speed) for each title group, and the date > that occurred. In case, ...
I haven't tried this, but I think it's correct. Let me
know if it's not.
select distinct table.title, table.date, t2.maxsp
from table,
(select title ttl, max(speed) maxsp from table group by ttl) t2
where table.title = t2.ttl and table.speed = t2.maxsp
Regards
